Assuming the vlookups are within C1:C10, an option to add up the vlookups
"as-is", ie without error-trapping for #N/As is to try something like this

In say, C11: =SUMIF(C1:C10,"<#N/A")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mike" wrote in message
...
I am trying to add vlookup figures together and some return #N/A, which
leads
to no values being returned at all. Is there anyway around this