Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Error with "TRUE"
Using VLOOKUP with the TRUE parameter on two sorted lists, Excel consistently
returns the value from the previous row if there is NOT an exact match. For example (the lookup range): Aberson Cats Acosta Apples Adair Apples Adkins Cats The results: Aberson Cats Acostan Cats Adair Apples Adkens Apples As you see, the two inexact matches (Acostan and Adkens) returned values from the lookup cell in the immediately preceding row rather than the value in the row with the similar name. VLOOKUP clearly is successfully doing the fuzzy match. It just won't return the right value. I've seen this before as well. Any suggestions? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Error with "TRUE"
This is how VLOOKUP works - if you want to get an exact match you
should set the fourth argument to FALSE or 0, whether or not the lookup table is sorted. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Error with "TRUE"
Thanks for your response but I do not want an exact match. I want a fuzzy
match. Excel is making a correct fuzzy match on row 2, but pulling the corresponding value from row 1. This can't be what's intended. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Error with "TRUE"
Ah. I think I see what you mean now. It doesn't make a fuzzy match at all.
It simply takes the next lowest value. Yes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |