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?

Attached Files

Macro-Test.xls (223.0 KB, 10 views)

Have you tried completing column "A" of that table portion of the Data sheet and using a SumProduct formula ?

Wow, just completed it and it worked like a charm with "Sumproduct". Thanks alot man!
Didn't know I could use that one. ++++++!

If you're interested in a reference...

Here's at least one...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Sweet, I'll read through it! Thanks.