vlookup with range reference

  • Thread starter Thread starter PsyberFox
  • Start date Start date
P

PsyberFox

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,
 
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
 
Clicked too soon.

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


Gord Dibben MS Excel MVP
 
Back
Top