Excel 2007 - I have vlookup formulas in cell c2 and d2. In c2 the result of
the vlookup is 5 and in d2 the results of the vlookup is #n/a. I then need
to sum cell c2 and d2 but I cannot since d2 contains #n/a. How can I
remove/change this so I can sum these two cells together?

Thanks!