| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP using the act shts tab name as a reference for the table_a
Hello, I was wondering if somebody could help me with a VLOOKUP formula.
VLOOKUP(A2,'MHP 01-03-2007 '!A13:T144,12,FALSE) Is there a way to adjust the formula above so that the MHP 01-03-2007 portion of the above formula will reference the active sheets tab name instead of hard coded text? any help would be appreciated. thanks, Tim -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Reference in Vlookup | Excel Discussion (Misc queries) | |||
| formula to add cells in multiple shts in the same wkbk | Excel Worksheet Functions | |||
| VLOOKUP Reference Help | Excel Discussion (Misc queries) | |||
| Vlookup reference a worksheet | Excel Worksheet Functions | |||
| How to Compare Rows on 2 shts .... | Excel Discussion (Misc queries) | |||
Threaded Mode
