Hi
I'd appreciate some help on how to nest a VLOOKUP (or a better method to do the following)
In Cell BE3 I have a persons name EG 'F Smith'
in Cell BF3 I have the reference T1I1
In cell BG3 I want to look up from a table in cells A3:Q12 what matches the combination of BE3 and BF3
In the table, the peoples names are in column 4 and the result to be returned to cell BG3 will come from column 16
Hope all that makes sense.
Can't seem to get this right.
Many thanks
Bookmarks