I need to get exact match with function like LOOKUP in EXCEL.
P Pete_UK Oct 2, 2008 #2 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
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
