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,