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?
Last edited by tangcla; 11-09-2009 at 08:39 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.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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.
Any chance you could upload a workbook, or shall we do "20 questions" ?
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
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.
=SUMIF($B$2:$B$1484, "JP11", $D$2:$D$1484)
The JP11 part can go in a cell, and you can repeat for other values.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
=SUMIF(B:B,"=*jp*",D:D)
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for that guys, didn't even think to use SUMIF.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks