Excell VLookup
 

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

Excell VLookup
 

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)

--
Biff
Microsoft Excel MVP


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

Excell VLookup
 

Hi Biff

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




"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


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

Excell VLookup
 

Sorry my error works a treat

thanks for your help much appreciated



"Rich" wrote:

Hi Biff

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




"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


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

Excell VLookup
 

Sorry my error works a treat

Thanks for your help, much appreciated


"Rich" wrote:

Hi Biff

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




"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


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

Excell VLookup
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Rich" wrote in message
...
Sorry my error works a treat

Thanks for your help, much appreciated


"Rich" wrote:

Hi Biff

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




"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


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