vlookup

[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.

 

[Don Guillett]

Where is your original thread. Always best to reply with top posting.

 

[Guest]

Please post your VLOOKUP formula, and the location and cell addresses of
your Named Range.

Vaya con Dios,
Chuck, CABGx3

 

[13hockey]

=VLOOKUP(E167,derek,9,FALSE)
derek is named range in next worksheet. I copied new data into the
worksheet and it worked.

 

[Dave Peterson]

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).

 

[Guest]

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