vlookup help

[JasonLeVan]

i have the formula below that works great execpt it wont match words or text just numbers is what can i do to make it match words also

=IF(ISNA(VLOOKUP(C3,A$3:B$7500,2,0)),0,VLOOKUP(C3,A$3:B$7500,2,0))

example: it finds the number 248 fine
but if that field say "test" it wont find test in column a and matching data in b

 

[SteveO59L]

No reason why your formula doesnt return the correct value.

Unless the text value has characters you cant see, such as leading or trailing spaces.

Try using the trim() or clean() functions on your text.