Is there a faster way of doing VLOOKUPs on multiple items?

**tangcla** · 11-09-2009, 06:12 PM

Instead of doing a long long formula that is =VLOOKUP(x1,....)+VLOOKUP(x2,.....) is there a faster way of doing it in the one formula?

**teylyn** · 11-09-2009, 06:42 PM

Yes, possibly with SUMIF, SUMPRODUCT or array formulae. If you can let us in on your data structure and calculation requirements, someone is sure to come up with a suggestion.

**tangcla** · 11-09-2009, 07:00 PM

I'm trying to search about six or eight values in the same column, and returning the value from the same column in all of my VLOOKUPs.

**teylyn** · 11-09-2009, 07:12 PM

Any chance you could upload a workbook, or shall we do "20 questions" ?

**tangcla** · 11-09-2009, 08:12 PM

Sure, 20 questions would be good - I didn't think there was much more information required as the value I'm looking up is irrelevant, as is the returned value.

In any case, here's the workbook in question; I wanted to vlookup values JP11, JP12, JP21, JP22, JP31, JP32, JP41, JP42, JPW1 and JPW2 from column B and return the sum of values in column D.