vlookup with range reference
 

Hi there,

Does anyone know how to successfully put a range reference in a vlookup
formula?

Let me explain:
I have a range set up as JanWeek1 (which refers to a range on another sheet
within the same workbook).
Now, the vlookup formula = vlookup(A1,Z1,3,0) but it gives me an error
because Z1 = "JanWeek1" (set up as text or general field). Is there another
way of doing this without sacrificing my reference to Z1 as the range
reference?

Thank you in advance,

vlookup with range reference
 

Hi
Try
= vlookup(A1,Indirect(Z1),3,0)

--
Regards
Roger Govier

"PsyberFox" wrote in message
...
Hi there,

Does anyone know how to successfully put a range reference in a vlookup
formula?

Let me explain:
I have a range set up as JanWeek1 (which refers to a range on another
sheet
within the same workbook).
Now, the vlookup formula = vlookup(A1,Z1,3,0) but it gives me an error
because Z1 = "JanWeek1" (set up as text or general field). Is there
another
way of doing this without sacrificing my reference to Z1 as the range
reference?

Thank you in advance,

vlookup with range reference
 

Blud-e marvelous! Thank you! I kinda thought I knew Excel, but obviously
there are a myriad of functions I know nothing about.
Thx again!
W

"Roger Govier" wrote:

Hi
Try
= vlookup(A1,Indirect(Z1),3,0)

--
Regards
Roger Govier

"PsyberFox" wrote in message
...
Hi there,

Does anyone know how to successfully put a range reference in a vlookup
formula?

Let me explain:
I have a range set up as JanWeek1 (which refers to a range on another
sheet
within the same workbook).
Now, the vlookup formula = vlookup(A1,Z1,3,0) but it gives me an error
because Z1 = "JanWeek1" (set up as text or general field). Is there
another
way of doing this without sacrificing my reference to Z1 as the range
reference?

Thank you in advance,

vlookup with range reference
 

Set the range up as =Sheet1!

On Mon, 11 Feb 2008 07:07:01 -0800, PsyberFox
wrote:

Hi there,

Does anyone know how to successfully put a range reference in a vlookup
formula?

Let me explain:
I have a range set up as JanWeek1 (which refers to a range on another sheet
within the same workbook).
Now, the vlookup formula = vlookup(A1,Z1,3,0) but it gives me an error
because Z1 = "JanWeek1" (set up as text or general field). Is there another
way of doing this without sacrificing my reference to Z1 as the range
reference?

Thank you in advance,

vlookup with range reference
 

Clicked too soon.

Roger has replied with good suggestion so ignore all of this<g


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 11:01:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Set the range up as =Sheet1!

On Mon, 11 Feb 2008 07:07:01 -0800, PsyberFox
wrote:

Hi there,

Does anyone know how to successfully put a range reference in a vlookup
formula?

Let me explain:
I have a range set up as JanWeek1 (which refers to a range on another sheet
within the same workbook).
Now, the vlookup formula = vlookup(A1,Z1,3,0) but it gives me an error
because Z1 = "JanWeek1" (set up as text or general field). Is there another
way of doing this without sacrificing my reference to Z1 as the range
reference?

Thank you in advance,