Vlookup Giving me headaches

[pariash]

Hello,

I am working on an inventory spreadsheet for work and I seem to be having issues with VLOOKUP. What I want to do is enter an item # like for example A123-456 and have the vlookup formular return the name of the manufacturer like Apple or whatever. I am using the formula as follows:

=vlookup(d2,table2,1,0) and all I get is #N/A.

I know the value above is a mix of text and numbers but I have seen tutorials where this works and I am stumped as to why I am getting #n/a.

Thanks in advance for any assistance.

 

[shadow12345]

are you sure there are no spaces in the item number list? Thats what normally trips me up.
Check that the range called table2 has the lookup value in the leftmost column


if there are you can use =trim(vlookup(d2,table2,1,0))

 

[pariash]

are you sure there are no spaces in the item number list? Thats what normally trips me up.
Check that the range called table2 has the lookup value in the leftmost column


if there are you can use =trim(vlookup(d2,table2,1,0))

No blanks and everything seems to be in order. In the item # field, there some item #s with spaces in the middle. Will that cause the issues?

Thanks,

 

[Aladin Akyurek]

Hello,

I am working on an inventory spreadsheet for work and I seem to be having issues with VLOOKUP. What I want to do is enter an item # like for example A123-456 and have the vlookup formular return the name of the manufacturer like Apple or whatever. I am using the formula as follows:

=vlookup(d2,table2,1,0) and all I get is #N/A.

I know the value above is a mix of text and numbers but I have seen tutorials where this works and I am stumped as to why I am getting #n/a.

Thanks in advance for any assistance.

What do you get with:

=LEN(D2)

and

=LEN(table2-cell that should match)

 

[pariash]

What do you get with:

=LEN(D2)

and

=LEN(table2-cell that should match)

I figured out my issue. I had to swap columns since the value I was looking up was not in the leftmost cell. When I swapped the columns it worked.

Thanks,