Is there anyway to write just ONE formula to get 0 when the #N/A is a result in the Vlookup?
Here is my Example:
Column H
=IF(VLOOKUP(A2,Sheet1!$A$4:$B$38,2,0),"0",VLOOKUP(A2,Sheet1!$A$4:$B$38,2,FALSE))
Column I
=ISNA(H2)
Column J
=IF(I2=TRUE,"0",H2)
Here is my Example:
Column H
=IF(VLOOKUP(A2,Sheet1!$A$4:$B$38,2,0),"0",VLOOKUP(A2,Sheet1!$A$4:$B$38,2,FALSE))
Column I
=ISNA(H2)
Column J
=IF(I2=TRUE,"0",H2)