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

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

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

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

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