VLOOKUP function

[Jay]

Hello,

My question involves VLOOKUP function. Please bare with
me as I try to explain my problem. The formula I am using
as my lookup is: =VLOOKUP($A35,DataMay,2,FALSE)

This lookup function does work correctly. But, I need to
make modifications to it to work correctly with another
report I'm trying to do.

As you'll notice, the lookup function is pointing to a
defined name: " DataMay ". Is it possible, to instead of
listing the defined name directly in the formula, that I
could have it point to a cell that would have the defined
name?

I want to do this because the report I am working on has
several defined ranges. And I want to easily change what
defined names it is looking up. Now without going to the
trouble of 'finding & replacing', is it possible to point
the formula to a cell that names the defined range?

I want to use a formula like: =VLOOKUP($A35,C1,2,FALSE)
and 'C1' would represent the name of the defined name I
want the VLOOKUP to look up.

Does this make any sense? And is it even possible?

Please let me know, I'd appreciate any help I could get
with this.

Thank you,
Jay Gustafson

 

[Bob Phillips]

Jay,

As ever, it is INDIRECT you need

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Eric]

Jay,

No problem, just modify your formula like this:

=VLOOKUP($A35,INDIRECT(C1),2,FALSE) where C1 contains your
named range.

It works like a dream.

Eric

 

[Mark Graesser]

Hi Jay
You can replace 'datamay' with an INDIRECT function

INDIRECT(A15

Change the A15 reference to your cell with the table name in it

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Jay wrote: ----

Hello

My question involves VLOOKUP function. Please bare with
me as I try to explain my problem. The formula I am using
as my lookup is: =VLOOKUP($A35,DataMay,2,FALSE

This lookup function does work correctly. But, I need to
make modifications to it to work correctly with another
report I'm trying to do

As you'll notice, the lookup function is pointing to a
defined name: " DataMay ". Is it possible, to instead of
listing the defined name directly in the formula, that I
could have it point to a cell that would have the defined
name

I want to do this because the report I am working on has
several defined ranges. And I want to easily change what
defined names it is looking up. Now without going to the
trouble of 'finding & replacing', is it possible to point
the formula to a cell that names the defined range

I want to use a formula like: =VLOOKUP($A35,C1,2,FALSE)
and 'C1' would represent the name of the defined name I
want the VLOOKUP to look up

Does this make any sense? And is it even possible

Please let me know, I'd appreciate any help I could get
with this

Thank you
Jay Gustafso

 

[DDM]

Jay, use the INDIRECT worksheet function. So:

=VLOOKUP($A35,INDIRECT($C$1),2,FALSE)

 

[Jay]

Thank you everyone for responding to my post. Your
answers worked perfectly. Exactly what I wanted. I'll be
posting another question to the group. Hope someone else
can help with that one too.

Thanks again!

Jay Gustafson