Using cell contents in Vlookup formula

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

I have the formula =VLOOKUP(B4,'September 2009'!database,2,0) which works
okay except I want the formula to read the month and year from an adjacent
cell. I thought the new formula should look something like
=VLOOKUP(B4,indirect(C4)!database,2,0) where cell C4 contains the text
September 2009.

Tried all sorts of formula but each returns either #REF! or #VALUE!

Any help would be much appreciated.

Rob
 
You need to build up the complete reference within INDIRECT, like so:

=VLOOKUP(B4,INDIRECT("'"&C4&"'!database"),2,0)

where C4 is assumed to contain September 2009.

Note the apostrophes - one inside the "" and one immediately before
the !

Hope this helps.

Pete
 
Thanks Pete, worked a treat.
Rob

You need to build up the complete reference within INDIRECT, like so:

=VLOOKUP(B4,INDIRECT("'"&C4&"'!database"),2,0)

where C4 is assumed to contain September 2009.

Note the apostrophes - one inside the "" and one immediately before
the !

Hope this helps.

Pete
 
Back
Top