VLOOKUP returning value when range_lookup false
 

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

VLOOKUP returning value when range_lookup false
 

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

VLOOKUP returning value when range_lookup false
 

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

VLOOKUP returning value when range_lookup false
 

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

VLOOKUP returning value when range_lookup false
 

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

VLOOKUP returning value when range_lookup false
 

Hi Jodie,

Not that formula as far as I can see, but you can get it with this somewhat
more convoluted formula

=INDEX($B$6:$B$20,MIN(IF(SUBSTITUTE(A23,"*","~")=S UBSTITUTE($A$6:$A$20,"*","
~"),ROW($A$6:$A$20)-ROW($A$6)+1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

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

"jodieg" .(donotspam) wrote in message
...
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

VLOOKUP returning value when range_lookup false
 

Thanks so much Bob!
--
Jodie

"Bob Phillips" wrote:

Hi Jodie,

Not that formula as far as I can see, but you can get it with this somewhat
more convoluted formula

=INDEX($B$6:$B$20,MIN(IF(SUBSTITUTE(A23,"*","~")=S UBSTITUTE($A$6:$A$20,"*","
~"),ROW($A$6:$A$20)-ROW($A$6)+1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

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

"jodieg" .(donotspam) wrote in message
...
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