G Guest Jan 30, 2007 #1 Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA
Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA
G Guest Jan 30, 2007 #4 Thank you very much!! Dave F said: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. Newbee said: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA Click to expand... Click to expand...
Thank you very much!! Dave F said: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. Newbee said: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA Click to expand... Click to expand...
G Gord Dibben Jan 30, 2007 #5 Just as long as you know that with ISERROR all errors will return 0, not just the NA. You may be hiding something you should know about. The ISNA trap will return 0 for data not found. =IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Gord Dibben MS Excel MVP Thank you very much!! Dave F said: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. Newbee said: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA Click to expand... Click to expand... Click to expand...
Just as long as you know that with ISERROR all errors will return 0, not just the NA. You may be hiding something you should know about. The ISNA trap will return 0 for data not found. =IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Gord Dibben MS Excel MVP Thank you very much!! Dave F said: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. Newbee said: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA Click to expand... Click to expand... Click to expand...
