vlookup with range reference

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,
 
P

PsyberFox

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
 
G

Gord Dibben

Clicked too soon.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic named range reference from external workbook 2
Vlookup using a reference to a named range?(Excel 2000) 4
Cell Reference on a different sheet 3
Creating a linked file based on variable location reference 2
VLOOKUP Column Index 5
how do i use the text in a cell as a named range in a vlookup form 2
Dynamic referencing to files 4
Vlookup cell reference 6

Top