How do I add vlookup functions together
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 |
How do I add vlookup functions together
Do you mean
=VLOOKUP(A1&B1,M1:P20,3,False) perhaps? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
How do I add vlookup functions together
you need to "trap" the error
if(isna(vlookup_formula),"",vlookup_formula).You could also have iserror.You can also have 0 instead of ""(blank).Your values should now add up -- paul remove nospam for email addy! "Mike" wrote: 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 |
How do I add vlookup functions together
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 |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com