I'm using this formula to test that two conditions are true and then doing a VLOOKUP to find an email address in a table:
=IFERROR(IF(AND(MATCH(B3,SU_LAT,0),MATCH(I3,SU_Name,0)),VLOOKUP(I3,'Internal Users'!email_lookup,4,FALSE),""),"")
However, if both the MATCH criteria are true but there is no entry in the cell that is looked up, the cell containing this formula returns a '0'. How can I avoid it doing so, I need to display '0's elsewhere on the sheet, so I can't turn it off in the Excel Options, I need to do it as part of the formula.
Can anyone help as I can't figure out how to do this?
Many thanks
Bookmarks