Vlookup not returning proper data

[shineboxnj]

=vlookup(A1,VENDOR,1,FALSE)
is returning #n/a

=vlookup(A1, vendor,1,true)
is returning the row above the correct name.

i have my data sorted ascending, and the range named Vendor. It is alphabetical, so I thought true should work, but either way shouldnt false work?

I am very confused about True or False in Vlookups...any recommendations?

[Domenic]

If you're looking for an 'exact' match, use FALSE. In this case, if it doesn't find an exact match, it returns #N/A.

If you're looking for an approximate match, use TRUE. In this case, if it doesn't find a n exact match, it returns the largest value that is less than the lookup value.

If you'd like help with the formula, please provide some details.

Hope this helps!

=vlookup(A1,VENDOR,1,FALSE)
is returning #n/a

=vlookup(A1, vendor,1,true)
is returning the row above the correct name.

i have my data sorted ascending, and the range named Vendor. It is alphabetical, so I thought true should work, but either way shouldnt false work?

I am very confused about True or False in Vlookups...any recommendations?

[olasa]

Try make a test:
If VENDOR =B1:B100 and the name that should be found is in B10.
Try test if A1=B10

Ola Sandstrom


Note:
Check that there are no blanks at the end: "Vendor1 " v.s. "Vendor1".
Blanks can be removed by the TRIM function (that is All blanks).

[shineboxnj]

the match is definitely there in VENDOR, exactly the same as cell A1. False just is not returning it, and True is returning the row above it.

Vendor is a list of all the vendors and addresses.
A1 is the vendor name, the formula is in B1.

Mark

[Domenic]

the match is definitely there in VENDOR, exactly the same as cell A1. False just is not returning it, and True is returning the row above it.

Have you tried Ola's suggestion? So, for example, if A1 contains the vendor name and B10 contains that value, try...

=A1=B10

...what result does the formula return?

Vendor is a list of all the vendors and addresses.
A1 is the vendor name, the formula is in B1.

If your list of vendors and addresses is contain in one column, try...

=VLOOKUP(A1&"*",VENDOR,1,0)

Hope this helps!

[shineboxnj]

=A1=b10 returned False

the vendor list is on a different worksheet...when i put the formula on the same worksheet it works fine. but i cant keep it there, so i need to figure out why it wouldnt work looking up from a seperate sheet. I have 4 different sheets looking up different sheets the same way without a problem, but this ones not working.

Mark

[Domenic]

=A1=b10 returned False

Check to make sure that there are no extra spaces in the cells.

[shineboxnj]

thats exactly what it was.. there were 5 blank spaces after the text that was exported from our warehouse software. I used the trim function, and it worked perfectly.
Wow that drove me nuts!

thanks for everyones help.

Mark