I think this fomula should work for you:
=INDEX($O$4:$R$14,MATCH(VLOOKUP(O17,$H$2:$L$31,3,0 ),$N$4:$N$14,1),MATCH(VLOOKUP(O17,$H$2:$L$31,4,0)-2,$O$3:$R$3,1))*VLOOKUP(O17,$H$2:$L$31,5,0)*$L$39
I had to alter some of the texts to make the formula work - but nothing
major.
Also see the attached zip-file:
http://www.excelforum.com/attachment...tid=3630&stc=1
Hope it helped
Ola Sandström
+-------------------------------------------------------------------+
|Filename: Prob2.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3630 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=390139