VLOOKUP #REF

  • Thread starter Thread starter GerryM
  • Start date Start date
G

GerryM

I have two sheets, one, Called "List" with 2500 rows in
col A codes which are repeated (not unique) COL B Price
and Col D Name of item, The other sheet "Sheet1" has 99
rows these are unique version of the codes in COL A
of "List". I want to use Vlookup to place the name of the
Item into Col B of Sheet1. I am using =VLOOKUP(A2,List!
A2:A2500,3,FALSE) and I get #REF error. Whete am I going
wrong, please
 
Hi

You're asking VLOOKUP to return the thrid column, but only given it one to
look at! Try this:
=VLOOKUP(A2,List!A2:C2500,3,FALSE)
 
Doh! So simple.

Many Thanks
-----Original Message-----
Hi

You're asking VLOOKUP to return the thrid column, but only given it one to
look at! Try this:
=VLOOKUP(A2,List!A2:C2500,3,FALSE)

--
Andy.





.
Click to expand...
 
Back
Top