Hello Oscar, Any chance this could be changed to generate brand new ensuing record all over several tabs, 23 rows for every single case? Therefore, the formulas in the next tab do ignore the basic 23 coordinating results, together with formulas on the 3rd loss create ignore the first 46 show, etcetera. Thank you so much,

Workbook step 1 and you will dos includes different study set – there are only a couple articles when you look at the worksheet step 1 that can be matched up so you’re able to worksheet 2. Worksheet step three was my sum exhibiting abilities.

You will find a design that around three workbooks

I do require study feel looked at to own criteria – that’s, I am just shopping for a-row during the Worksheet 2 you to definitely keeps a few particular articles one to fits a couple of particular articles for the an excellent line within the Worksheet step 1. I wish to have a look at a specific telephone of every of these rows where reputation could have been turned out.

It issues is a lot like the one printed at the first of thread, but not we need higher liberty inside requirements. Essentially we wanted for each and every row when you look at the worksheet 2 to get scanned against worksheet 1 and you will, in the event the a lot more than conditions is satisfied, display a mobile away from you to definitely coordinating line.

Please skip my personal previous post

I would like specific tissue inside worksheet dos off rows in which: ‘renter name’ into the worksheet 2 fits ‘building/tenant’ during the worksheet step one and in which ‘premises’ from inside the worksheet dos fits ‘suite id’ when you look at the worksheet step 1. Curlington Judge Asking are an example of eg a match.

I also need an extra tests – that is, really don’t wanted one data off worksheet step one (whether or not one another earlier in the day sphere was came across) if your expiry is more than half a year aside.

I wish to lookup a primary vertical assortment, and then an extra vertial range, after which referce the brand new cellphone regarding the 3rd line where the range lookups try genuine.

age.g. We search variety A1:A10 seeking the worthy of step 1, and acquire they when you look at the A1 and A2. Today I would like to narrow this off by appearing diversity B1:B10 (I’m indeed looking B1:B2 now) to get a second value and acquire they inside B2. Therefore, the really worth I wish to refence in C2. How do i do this. It is similar to your first analogy except in my own circumstances, AX and you can BX will always be book and i must source telephone CX.

Hey Oscar, thanks for your own help. While i never upload your file having alter, i could you will need to determine why.

Take note, yet not, the matching data are not in the same rows on every worksheet. On your 1st try, the coordinating ‘tenant name’ and premises’ come into a similar rows of each data worksheet. All else you presumed, although not, is perfect.

It’s very vital that you remember that where there were a complement utilized in worksheet step 1 and you may dos for ‘occupant name’ and ‘premises’, this is exactly unique. This kind of a meeting, I’d like most other studies returned out of worksheet that, eg just what has been done in your first design.

As stated in past times, i really daddyhunt Hoe te gebruiken need an answer that essentially goes through each line myself more most of the line when you look at the worksheet 2, and where a fit receive, most other analysis out of worksheet step one try exhibited within the worksheet step three. It will be a in the event the there can be a controlled mistake message (we.e. how you can display screen need text message in the ‘=if=’ attributes) in which data is maybe not discovered, to ensure i can after that type the outcome webpage by an effective types of metric, except if you really have a feminine solution.