05192017, 01:19 PM  #1 
Novice
Join Date: May 2017
Posts: 6

Formula to depend on multiple cellvalues
Hey guys.
Another problem I can't solve, but I guess it's kinda simple. Been trying with vLookup but doesn't get it to work I want cell H10 to check what value cell B10 has (there are 6 different ones cuz it's a dropdownlist). And also check what value cell D10 got. And from that, evaluate the value to be shown in cell H10. The data it will check for is on Sheet3 "DATA". For example. If B10 = Tidningar & D10 = 370L. H10 should show the result of DATA!D17  "81". ref. (B10 = Tidningar 'Check Sheet3 > A16' => then check D10 = 370L 'Check Sheet3 > B17 => H10 = 81) If they collumns or so are missplaced, feel free to put them in the right order The DATA sheet3, has all the rawdata for my formulas. Why I want it to depend on B10 is beacuse it's not yet complete and the other ones got different prices. Is it possible to do this? 
05202017, 10:20 AM  #2  
Excel Hobbyist
Join Date: Nov 2013
Posts: 485

Quote:
Code:
=SUMPRODUCT((Data!$A$16:$A$37=Kalkyl!$B10)*(Data!$B$16:$B$37=Kalkyl!$D10)*(Data!$D$16:$D$37)) 

05202017, 11:19 AM  #3  
Novice
Join Date: May 2017
Posts: 6

Quote:
Didn't know I could use that one. ++++++! 

05202017, 12:20 PM  #4 
Expert
Join Date: Apr 2016
Posts: 380

If you're interested in a reference...
Here's at least one... http://www.xldynamic.com/source/xld.SUMPRODUCT.html 
05232017, 04:04 AM  #5  
Novice
Join Date: May 2017
Posts: 6

Quote:


Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Find and replace multiple values, according to table value  excel formula  EtanM  Excel Programming  3  04112016 01:43 AM 
IF Formula  multiple values  Jac_Fcb  Excel  1  03172015 12:41 AM 
I need to add multiple values based on multiple criteria in a cell not sure what to do  AUHAMM  Excel  3  10272014 09:11 PM 
How to count multiple values in a single cell, except zero?  iuliandonici  Excel  1  04132011 09:45 PM 
Sum & difference between multiple values in a single cell  iuliandonici  Excel  4  04132011 09:27 PM 