Excell VLookup

[Rich]

Hi All

I am trying to set the "table_array' part of this formula an individual
cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38

=VLOOKUP(A8,'15.04.08'!A3:K38,7)

Basically trying to define which worksheet to look in for the value.

Hope this makes sense

Cheers

 

[T. Valko]

I'm assuming the lookup table is in the *same* range on the different
sheets.

A7 = sheet name = 15.04.08

=VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7)

 

[Rich]

Hi Biff

just tried this with no joy, responds with a #Ref error, and yes the lookup
is the same range on each sheet

 

[Rich]

Sorry my error works a treat

thanks for your help much appreciated

 

[Rich]

Sorry my error works a treat

Thanks for your help, much appreciated

 

[T. Valko]

You're welcome. Thanks for the feedback!