VLOOKUP

Giganews Newsgroups
Subject: VLOOKUP
Posted by:  Mike McLellan
Date: Wed, 3 May 2006

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,"yyyymmdd"),"\[",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?

Replies