Vlookup with '-' in lookup Cell

Hi,

Can anybody help with following problem?

I have in a cell the e.g. value: 1542-D14
But the Vlookup Function gives me an error, because he can't find it.

The lookup values could be a regular number with 7numbers e.g. 8002548 or 8 digits with a dash and a letter in it e.g. 1541-D13

So I want a formular that shows me a "No" in case I find my looked up value and a "Yes" in case it can't find the value.

=IF(VLOOKUP(G436;$G$374:$G$422;1;FALSE); "No"; "Yes")

This is what I have, but it's only giving me the 'No' for the 7 digits numbers in case Excel can find the value in my lookup range.

Cheers,
Marianne

Try

=IF(ISNA(MATCH(G436;$G$374:$G$422;0));"Yes";"No")

OMG - thanks Jonmo1! This is fantastic! Thanks a lot!

You're welcome..

FYI, if a TRUE or FALSE result is sufficent instead of Yes or No, you can just do

=ISNA(MATCH(G436;$G$374:$G$422;0))