My formula is returning an #N/A when there is no match from my data source file, meaning I have an account name on my main sheet where the formula resides but on the data source sheet, this account name does not exist, therefore the formula returns the #N/A, how can I get the formula to return a Zero, I played around with an IF(ISNA) and an ISERROR, but could not get to work, I got the ISERROR to identify accounts not present on the data source sheet, but would rather just have the formula return a Zero, any suggestions?
=INDEX('data source sheet'!$B$1:$C$500,MATCH(A164,'data source sheet'!$A$1:$A$500,0),MATCH($C$1,'data source sheet'!$B$1:$C$1,0))
Bookmarks