Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I want to use VLOOKUP to help produce a summary spreadsheet from a number of
files. Cell C10 contains - =CONCATENATE("D:\Documents and Settings\fzvtc6\My Documents\EDS Documents\Shared\Excel\LPS\SLA\",TEXT($A10,"yyyymm dd"),"\[",TEXT($A10,"yyyymmdd")," - Weekly - All locations - LPS - Live.xls]Weekly!$A$1:$Z:50") which evaluates as - D:\Documents and Settings\fzvtc6\My Documents\EDS Documents\Shared\Excel\LPS\SLA\20060320\[20060320 - Weekly - All locations - LPS - Live.xls]Weekly!$A$1:$Z:50 In cell F10, I want to be able to incorporate a call to VLOOKUP along the following lines - =VLOOKUP(D10,INDIRECT(C10),3,FALSE) When I try this, I get an #REF! error. Can anyone tell me where I'm going wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |