vlookup

  • Thread starter Thread starter mike.kelly
  • Start date Start date
M

mike.kelly

when I changed the worksheet that vlookup goes to "named range" the
vlookup returned #ref, even though in new worksheet I used same named
range.

1) Does it have to be same size of range?
2) Can I just copy the new data into the old worksheet
3) Should I use a dynamic named range?
Thanks.
 
Where is your original thread. Always best to reply with top posting.
 
Please post your VLOOKUP formula, and the location and cell addresses of
your Named Range.

Vaya con Dios,
Chuck, CABGx3
 
=VLOOKUP(E167,derek,9,FALSE)
derek is named range in next worksheet. I copied new data into the
worksheet and it worked.
 
If the range name derek doesn't have 9 columns, you can get that error (since
you're trying to return the value from the 9th column of that range).
 
Glad you got it working......yeah, sometimes VLOOKUP's run into a problem
between numerical and text formats, which may have been your case......."it
looks like a number but is really text" and VLOOKup won't see it........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Referencing Multiple Worksheets using VLOOKUP and INDIRECT 3
Dynamic Range broken 1
Speek cells, barcode scanner 3
Range referencing in VLOOKUP function, string concatenate? 4
Formula help please 1
incorporate paste value in vlookup 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel VBA 1

Back
Top