Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get exact match with LOOKUP function?
I need to get exact match with function like LOOKUP in EXCEL.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get exact match with LOOKUP function?
You can usually use VLOOKUP or HLOOKUP (or even MATCH with INDEX), and
these have an optional 4th parameter (3rd for MATCH) which if set to 0 or FALSE indicate that you want an exact match. Hope this helps. Pete On Oct 2, 12:58*pm, s51janez wrote: I need to get exact match with function like LOOKUP in EXCEL. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup- Closest match that contains the exact lookup value? | Excel Worksheet Functions | |||
Lookup Exact Match | Excel Worksheet Functions | |||
Lookup and Match with not exact numbers | Excel Worksheet Functions | |||
Match - Exact - Lookup? | Excel Worksheet Functions | |||
Lookup returns message box when an exact match is not found | Excel Worksheet Functions |