Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup match greater than lookup value
Help! My vlookup formula produces a match that is greater than the lookup
value. The values in the first column of the table is in ascending order and none of them are text. It's driving me crazy! -- papi |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup match greater than lookup value
Did you miss the "FALSE" parameter in the statement?
i.e. VLOOKUP(key,range,col,FALSE) The parameter will force the function to find an exact match. If all else fails - try help. -- Regards Rob "papio5949" wrote in message ... Help! My vlookup formula produces a match that is greater than the lookup value. The values in the first column of the table is in ascending order and none of them are text. It's driving me crazy! -- papi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup match greater than lookup value
Hello papi,
What formula are you using and what is the lookup value? "RobWN" wrote: Did you miss the "FALSE" parameter in the statement? i.e. VLOOKUP(key,range,col,FALSE) The parameter will force the function to find an exact match. If all else fails - try help. -- Regards Rob "papio5949" wrote in message ... Help! My vlookup formula produces a match that is greater than the lookup value. The values in the first column of the table is in ascending order and none of them are text. It's driving me crazy! -- papi |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup match greater than lookup value
I am not using "false" as I do not want an exact match. Thanks for your reply.
-- papi "RobWN" wrote: Did you miss the "FALSE" parameter in the statement? i.e. VLOOKUP(key,range,col,FALSE) The parameter will force the function to find an exact match. If all else fails - try help. -- Regards Rob "papio5949" wrote in message ... Help! My vlookup formula produces a match that is greater than the lookup value. The values in the first column of the table is in ascending order and none of them are text. It's driving me crazy! -- papi |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup match greater than lookup value
Hi daddylonglegs,
I found a solution - I used Match along with Vlookup and it corrected it. Thanks for you concern. -- papi "daddylonglegs" wrote: Hello papi, What formula are you using and what is the lookup value? "RobWN" wrote: Did you miss the "FALSE" parameter in the statement? i.e. VLOOKUP(key,range,col,FALSE) The parameter will force the function to find an exact match. If all else fails - try help. -- Regards Rob "papio5949" wrote in message ... Help! My vlookup formula produces a match that is greater than the lookup value. The values in the first column of the table is in ascending order and none of them are text. It's driving me crazy! -- papi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup. Match. Lookup. Wtf? | Excel Discussion (Misc queries) | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
lookup finding the next value that is GREATER | Excel Worksheet Functions | |||
vlookup - finding the next value that is GREATER than the lookup value? | Excel Worksheet Functions | |||
match,lookup or vlookup???? | Excel Discussion (Misc queries) |