View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default LOOKUP is working - but VLOOKUP is not

Hi,

i am trying to use vlookup to grab the price of an item in one sheet based
on a part number.

I am getting a ref error - when I set the col index to 1, it returns the
value that I'm looking for, once i increase the col index to grab the
adjacent column, I get the ref error.

The data i am searching through is sorted ascending. It is formatted as
General, and the numbers look like: 555-555-55-55.

the function looks like this:
=VLOOKUP(A105,'nsi 12-4'!A:A,2,FALSE)

i would appreciate any help