lookups with a twist

[SteveO59L]

i have a master sheet with names in col A, dates in row 1, and a value at the intersect.


i would like to update this Master sheet from another sheet which is a dump from another programme.

i can do a vlookup to find the name in the update sheet, but that requires identifying the column matching the dates.

is there a way to not only lookup the name, but also the corresponding date?

 

[Joe4]

I am not sure I fully understand your data structure. I think there is a situation in which it would be much clearer if we could get a visual representation of your data and what you are trying to do.

Can you post examples of your Master sheet, underlying sheet, and expected results?

 

[Fluff]

You can do that with index/match/match How to use INDEX and MATCH | Exceljet

 

[SteveO59L]

so, when the update data is refreshed, i would the Master to lookup (say) Jim for the 8th Nov

i know i can use =VLOOKUP($A7,$A$17:$T$20,7,FALSE), but i am after a method of replacing the "7", with something to look up the date,

 

[Fluff]

Have you had a look at the link I provided?

 

[SteveO59L]

Have you had a look at the link I provided?

indeed, i have.

solved,

thank you very much for your help

 

[Fluff]

Glad we could help & thanks for the feedback.