Summing Vlookup results

[hallingh]

This probably isn't a very difficult question, but I have no clue how to do it. I have a vlookup formula which is working great if it only finds one value, but if there are more than one value it finds I need it to sum the two together and display the result. Here is my formula:

IF(ISERROR(VLOOKUP($A15,data.Custom!B$4:L$18,11,FALSE)),0,VLOOKUP($A15,data.Custom!B$4:L$18,11,FALSE))

I would greatly appreciate help on how to adjust this formula so it will add multiple returned values together and display the result. Thanks for any help you can give me!

Hank

 

[hallingh]

Nevermind, I realized I can just use SUMIF. Stupid!

I have another question, though. Theres another vlookup I use to accomplish the same thing, except it is looking up text values instead of numerical values. Is there any way to show all of the text values found from the vlookup?