VLOOKUP Returns #N/A

[tantcu]

Hello,

I'm using function Vlookup and it returns errors and I could not figure out why. Please help


VLOOKUP ERROR.xlsx

[Jonmo1]

It's the tilde's (~).

That's one of Excel's "special" little characters.
And any kind of match function really hates them.

Use find replace to remove them from both tables.

but in the FindWhat window, put 2 tilde's...yes 2.. ~~

[Pete_UK]

It is because you have the ~ character in your strings. This is used as an "Escape" character in some instances, to enable you to find wildcard characters for example - it can be read as "take the next character literally". If you highlight column B and do Find & Replace (Ctrl-H) and:

Find what: ~~
Replace with: _
Click Replace All

(Note that you have to type ~ twice in the Find box), then that will replace the ~ character with an underscore (could be anything), and you will see that your formulae now work correctly.

Hope this helps.

Pete

[tantcu]

Thanks so much guys