tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
In column A, I have 5 rows, a,b,c,d,e. In cell C1 have the value c.
In cells D1, I have this formula:
which returns 3 as expected.
If instead column A contained a, "",c,d,e and cell C1 contains a blank cell, the match function returns N/A.
How can I change to return the value of 2?
Thanks
In cells D1, I have this formula:
Code:
=Match(C1,A1:A5,0)
which returns 3 as expected.
If instead column A contained a, "",c,d,e and cell C1 contains a blank cell, the match function returns N/A.
How can I change to return the value of 2?
Thanks