Is there a way to prevent it from viewing it as a wildcard and as a character
with value instead?
--
Jodie Gardner


"Bob Phillips" wrote:

It is treating the * as wildcards.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jodieg" .(donotspam) wrote in message
...
Here is my formula:
=VLOOKUP(A23,MFRPT11.XLS!$A$6:$B$20,2,FALSE)
It is matching the numbers for both of the following values:
*******MIXED ADC
*AUTO**MIXED ADC
even though they are not exactly the same.
--
Jodie

Pete_UK" wrote:

Post your formula with a description of when this happens, and we might
be able to help you.

Pete

jodieg donotspam wrote:
Hello!
I have "false" as my range_lookup in VLOOKUP. It is still returning a
match
to something that is not exact. Am I doing something wrong?
Thanks!
--
Jodie