Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use tab name in Vlook Up
I have a formula that looks up data in a sheet using Vlookup, every week the
formula changes as the week number changes. The tab to look for data has a tab name of wk## and thus the forumla for week 28 looks like this =VLOOKUP(O2,wk28!A4:L3000,12,FALSE) How can I substitue the wk28 tab number in the formual for a cell reference that contains the text "wk28" ? This will save me modifying forumlas on weekly basis. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
vlook | Excel Worksheet Functions | |||
Need Help about vlook | Excel Worksheet Functions | |||
#N/A with Vlook up | Excel Discussion (Misc queries) |