wind0wlicker
New Member
- Joined
- Oct 3, 2022
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
Hello, I'm fairly new to excel and was hoping I could get some help. I'm trying to add an IF statement to the following so that if a cell has 0 then it will change to a blank/empty cell/nothing shows. The 0's populate in columns A and B of another sheet that is not Sheet1 (source data), but instead called "Ent". Is this possible? Any help would be appreciated.
=IFERROR(INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,)),"")
I was thinking of something along the lines of:
=IF(A2=0,"",A2) or =IF(A:A=0,"",A:A)
=IFERROR(INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,)),"")
I was thinking of something along the lines of:
=IF(A2=0,"",A2) or =IF(A:A=0,"",A:A)