Matching cells but exclude blanks
Solved/Closed
Tom9o
Hira - Jul 4, 2017 at 08:18 AM
- Posts
- 11
- Registration date
- Monday February 18, 2013
- Status
- Member
- Last seen
- September 15, 2013
Hira - Jul 4, 2017 at 08:18 AM
Related:
- Index match ignore blank cells
- Excel index match ignore blank cells - Best answers
- Index match skip blanks - Best answers
- Macro copy and paste in next blank cell - Guide
- Macro copy and paste in next blank cell ✓ - Forum - Excel
- Find and replace blank cells in excel ✓ - Forum - Programming
- Macro that goes to next blank cell ✓ - Forum - Programming
- Copy and paste only non-blank cells with vba code ✓ - Forum - Excel
10 replies
Zohaib R
Mar 11, 2013 at 02:36 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Mar 11, 2013 at 02:36 PM
Hi Tom9o,
If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, enter the below mentioned formula in C1 and it should work now:
=IF(ISBLANK(A1),"",IF(B1=A1,A1,""))
Do reply with results.
If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, enter the below mentioned formula in C1 and it should work now:
=IF(ISBLANK(A1),"",IF(B1=A1,A1,""))
Do reply with results.
Jul 4, 2017 at 08:18 AM