| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - WISH TO SUBSTITUTE FALSE FOR A VALUE | Excel Discussion (Misc queries) | |||
| vlookup returning a #N/A value | Excel Worksheet Functions | |||
| vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
| Shorten a Macro | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
Hybrid Mode
