vlookup on several columns

[ddesantis]

Hi,
I have a unique identifier and I need to look for it across multiple tables; all these tables are in a single tab.
Once I find this ID I always need to get the +2 column number

I tried
- vlookup, but the ID has always to be on the first column, and this is not the case
- Index and match but I've to generate multiple index and match and specify exactly the columns where the possible result is.
Hope I've been clear, please let me know if you can help
Thanks
Daniele

 

[ghrain22]

https://www.youtube.com/watch?v=iAE9a0uRtpM

You can do this for each entity and use it in an index match formula. Even if this isn't the route you go i highly suggest looking into named ranges. They can make working with data easier and your longer formulas more ledgable