"#N/A" Result From VLOOKUP Formula
I need a way to return a value of 0 when a formula results in a #N/A value.
Can this be done? My problem is where I have a VLOOKUP and the lookup value does not exist. |
"#N/A" Result From VLOOKUP Formula
You could use the following IF:
IF(ISERROR(VLOOKUP(xx,xx,xx)),0,VLOOKUP(xx,xx,xx)) -- Kevin Backmann "jose3106" wrote: I need a way to return a value of 0 when a formula results in a #N/A value. Can this be done? My problem is where I have a VLOOKUP and the lookup value does not exist. |
"#N/A" Result From VLOOKUP Formula
=if(isna([your vlookup]),0,[your vlookup])
Dave -- Brevity is the soul of wit. "jose3106" wrote: I need a way to return a value of 0 when a formula results in a #N/A value. Can this be done? My problem is where I have a VLOOKUP and the lookup value does not exist. |
"#N/A" Result From VLOOKUP Formula
=IF(ISNA(VLOOKUP Formula)),0,VLOOKUP Formula))
With actual formula.............. =IF(ISNA(VLOOKUP(A1,$B$1:$C$32,2,FALSE)),"",VLOOKU P(A1,$B$1:$C$32,2,FALSE)) Gord Dibben MS Excel MVP On Tue, 5 Sep 2006 10:43:02 -0700, jose3106 wrote: I need a way to return a value of 0 when a formula results in a #N/A value. Can this be done? My problem is where I have a VLOOKUP and the lookup value does not exist. |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com