ExcelBanter - How to get exact match with LOOKUP function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get exact match with LOOKUP function? (https://www.excelbanter.com/excel-worksheet-functions/204780-how-get-exact-match-lookup-function.html)

s51janez

How to get exact match with LOOKUP function?

I need to get exact match with function like LOOKUP in EXCEL.

Pete_UK

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.

All times are GMT +1. The time now is 02:24 AM.