Hi folks I need some help...
I need to do a VLOOKUP() on an array that I'm dynamically working out...
A1 holds the name of the person I'm looking up
A2 holds the row number of the first row in the target array (eg 80)
The target array will be 25 rows by 10 columns in worksheet 'Yearly Results' starting at Column 'A' in the row defined in A2
In this case the target array should be 'YearlyResults'!A80:J104
I've tried both
=VLOOKUP(A2,OFFSET(ADDRESS(A1,1,1,1,"Yearly Results"),0,0,25,10),5,FALSE)
=VLOOKUP(A2,INDIRECT(OFFSET(ADDRESS(A1,1,1,1,"Yearly Results"),0,0,25,10)),5,FALSE)
I'd very much appreciate it if anyone can suggest a correction to this...
Thanks, Paddy.
Bookmarks