Help using an IF function in a formula that uses IFERROR & INDEX

[wind0wlicker]

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)

 

[bebo021999]

Instead of trying to change column A from 0 to "", change in formula to get "" if column A = 0

=IFERROR(IF(INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,))=0,"",INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,))),"")

 

[wind0wlicker]

Instead of trying to change column A from 0 to "", change in formula to get "" if column A = 0

=IFERROR(IF(INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,))=0,"",INDEX(Sheet1!A:A,Match(E2,Sheet1!E:E,))),"")

Thank you very much