Vlookup

[mbunting]

Is it possible to create a lookup where the data you are trying to lookup doesn't exist in the range so it returns the number 0 rather than NA. I an using the returned data from the lookup in a colum that is being totaled and the NA ruins the sum total of the column??

 

[njimack]

=IF(COUNTIF(lookup_range,lookup_value),VLOOKUP_formula,0)

 

[scottylad2]

try = If(ISNA(vlookup here),0,vlookup here for 2003 and earlier

or for 2007 and later

=Iferror(Vlookup here),0)

 

[texasalynn]

use an if statement - here is an example

=IF(ISNA(VLOOKUP(D5737,'[SAPEmps 091211.xls]Sheet1'!$K:$K,1,FALSE)),0,VLOOKUP(D5737,'[SAPEmps 091211.xls]Sheet1'!$K:$K,1,FALSE))

 

[mbunting]

That worked, Thanks