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
|