Weird VLOOKUP issue

[zerovector]

Hello,

I was wondering why Vlookup would be returning a value when the value does not exist in another table, and I have the Range_Lookup set to 0 (or false).

The value I am looking up is


579190*202

This value does NOT exist in the table (I want it to return N/A)

The value it keeps looking up is:

579190*1202 2.98

Does this have to do with the lookup index being a text value? Does the Range_Lookup not trigger on text values?


When I change the lookup key to

579190202

The value it returns is:

#N/A



Is this normal? Thanks so much

 

[Aladin Akyurek]

Care to post the formula you have?

 

[zerovector]

=VLOOKUP(C14,'482'!D$4:F$3109,3,0)

 

[Andrew Poulsom]

The * is a wildcard in VLOOKUP. To find an actual * you need to precede it with a tilde, eg:

=VLOOKUP(SUBSTITUTE(A1,"*","~*"),C:C,1,0)

 

[zerovector]

The * is a wildcard in VLOOKUP. To find an actual * you need to precede it with a tilde, eg:

=VLOOKUP(SUBSTITUTE(A1,"*","~*"),C:C,1,0)

Thank you. I thought it was something along those lines.