Is there a way to make a single column table array in a vlookup dynamic and move the table array by x columns to the right? The number of columns to the right would be defined in the same row as the vlookup formula.
Is there a way to make a single column table array in a vlookup dynamic and move the table array by x columns to the right? The number of columns to the right would be defined in the same row as the vlookup formula.
ScreenShot001.jpg
vlookup dynamic table array.xls
eg screenshot and spreadsheet attached.
so the vlookup would return #n/a at row number 12 as the number 1 doesn't appear in table 2
Insert in C5, copy down:
=VLOOKUP(B5,OFFSET($C$20,0,A5):OFFSET($C$28,0,A5),1,FALSE)
Fantastic!! Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks