Using cell contents in Vlookup formula
 

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

Using cell contents in Vlookup formula
 

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

On Sep 14, 8:18*pm, "Rob" wrote:
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

Using cell contents in Vlookup formula
 

Thanks Pete, worked a treat.
Rob

"Pete_UK" wrote in message
...
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

On Sep 14, 8:18 pm, "Rob" wrote:
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

Using cell contents in Vlookup formula
 

You're welcome, Rob - thanks for feeding back.

Pete

On Sep 14, 9:02*pm, "Rob" wrote:
Thanks Pete, worked a treat.
Rob

"Pete_UK" wrote in message

...
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

On Sep 14, 8:18 pm, "Rob" wrote:



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- Hide quoted text -

- Show quoted text -