excel - nesting INDIRECT inside a VLOOKUP?

[brightshadow]

Is it possible to nest an INDIRECT function inside of a VLOOKUP?

Here's what I've got so far:

Cell A27: 6-23-2004

Cell B27:
=VLOOKUP(B$4,'6-23-2004'!$A$1:$C$70,3,FALSE)/60/60/24

I want to replace '6-23-2004' with INDIRECT($A27) so I can autofill
this formula across a large worksheet, and so when I adjust the date
range, it will dynamically update the information PROPERLY according to
the name (row 4 of same col) and date (col A of same row, referring to
a separate worksheet in the same workbook by that name) in the
formula.

I can't seem to get the syntax right. Is there a right syntax? I'm not
just trying to do something that isn't possible, am I?

 

[Chip Pearson]

Try something like

=VLOOKUP(B$4,INDIRECT($A27&"!$A$1:$C$70"),3,FALSE)/60/60/24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"brightshadow >" <<[email protected]>
wrote in message
news:[email protected]...