ExcelBanter - MATCH Function

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

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

- - MATCH Function (https://www.excelbanter.com/excel-worksheet-functions/267544-match-function.html)

rge0036

MATCH Function

Using the MATCH function, I want the lookup_value to be a blank cell. I have tried =MATCH(,O18:O72,0) and =MATCH("",O18:O72,0) but neither work. How do I set the lookup_value to be a blank??

All times are GMT +1. The time now is 03:44 PM.