=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?