| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup question | Excel Worksheet Functions | |||
| Question on Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Question. | Excel Discussion (Misc queries) | |||
| Vlookup question | Excel Discussion (Misc queries) | |||
| Vlookup Question | Excel Discussion (Misc queries) | |||
Linear Mode
