VLookUp Question
 

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.

VLookUp Question
 

Try:
=VLOOKUP(A2,INDIRECT(B1),4,0)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496700