Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |