=IF(ISERROR(=VLOOKUP(A3, ELMAX, 2,)),"0",(=VLOOKUP(A3, ELMAX, 2,)))


"GD" wrote:

Hi, i have a lookup i'm currently using; "=VLOOKUP(A3, ELMAX, 2,)" I want to
expand this formula to include an IF(ISNA aspect as when the value being
looked up doesn't occur in the lookup table i am getting #N/A!'s and want to
have them come through as zeros...any thoughts?