vlookup table_array
 

Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade

vlookup table_array
 

Hi,

Use indirect

=VLOOKUP(2,INDIRECT(C1),2,FALSE)

Where c1 is your table name

Mike

"A" wrote:

Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade

vlookup table_array
 

Thanks for the quick response Mike

"Mike H" wrote:

Hi,

Use indirect

=VLOOKUP(2,INDIRECT(C1),2,FALSE)

Where c1 is your table name

Mike

"A" wrote:

Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade

vlookup table_array
 

You would use INDIRECT to do this:

=VLOOKUP(A1,INDIRECT(A2),2,FALSE)

This assumes that keep is in the same workbook, as INDIRECT will only
work with workbooks that are open - if it is in a different workbook
which is open, you will need to include the filename in A2.

Hope this helps.

Pete

On Jul 31, 11:48 am, A wrote:
Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade

vlookup table_array
 

I'm trying to do the same thing except I'm referencing a range in a different
worksheet. It works if the other worksheet is open but I need it to work with
it closed.

Thanks


--
Hold On Everybody!


"Pete_UK" wrote:

You would use INDIRECT to do this:

=VLOOKUP(A1,INDIRECT(A2),2,FALSE)

This assumes that keep is in the same workbook, as INDIRECT will only
work with workbooks that are open - if it is in a different workbook
which is open, you will need to include the filename in A2.

Hope this helps.

Pete

On Jul 31, 11:48 am, A wrote:
Hi all
my vlookup formula uses a named range (eg keep in the formula below) as the
table array. Is there any way of putting the name of the range as text in
cell A2 and linking A2 in the vlookup?

=VLOOKUP(A1,keep,2,FALSE)
=VLOOKUP(A1,?+A2?,2,FALSE)

Thanks
Ade