TB's Code Library
If it ain't tight, it ain't right!
Search
Monday, December 05, 2005
Trapping for instance of #NA in Excel
Trapping for instance of #NA in an excel vlookup and replacing with a 0 (zero) so you can use the value in a sum formula
=IF(ISNA(VLOOKUP(A3,'Sheet1'!$A$4:$K$907,5,FALSE)),0,VLOOKUP(A3,'Sheet1'!$A$4:$K$907,5,FALSE))
Newer Post
Older Post
Home