I have the vlookup formula below in b2. My table names are in row1 (Jan,Feb).
Is it possible to have the lookup formula refer to cell b1 for the name of
the table.
Jan Feb
QQQQ =VLOOKUP(A2;B1;4;FALSE)
Thank you in advance.
I have the vlookup formula below in b2. My table names are in row1 (Jan,Feb).
Is it possible to have the lookup formula refer to cell b1 for the name of
the table.
Jan Feb
QQQQ =VLOOKUP(A2;B1;4;FALSE)
Thank you in advance.
Try:
=VLOOKUP(A2,INDIRECT(B1),4,0)
HTH
JG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks