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

LOOKUP is working - but VLOOKUP is not
 

You should include the adjacent column into the lookup table:

=VLOOKUP(A105,'nsi 12-4'!A:B,2,FALSE)

Regards,
Stefi

€žjay€� ezt Ã*rta:

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

LOOKUP is working - but VLOOKUP is not
 

Thank you Stefi!


"Stefi" wrote:

You should include the adjacent column into the lookup table:

=VLOOKUP(A105,'nsi 12-4'!A:B,2,FALSE)

Regards,
Stefi

€žjay€� ezt Ã*rta:

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

LOOKUP is working - but VLOOKUP is not
 

You are welcome! Thanks for the feedback!
Stefi

€žjay€� ezt Ã*rta:

Thank you Stefi!


"Stefi" wrote:

You should include the adjacent column into the lookup table:

=VLOOKUP(A105,'nsi 12-4'!A:B,2,FALSE)

Regards,
Stefi

€žjay€� ezt Ã*rta:

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