Excel Formula Help

[Desmo]

Hey hey :D

Need some help with this formula that my dumb excel brain can't get to work.

http://img.photobucket.com/albums/v112/piggymon/Odds%20and%20Ends/excelchart.png

This is a very simplified chart, but what I need to do is cross reference some of the information when I fill in the fields.
What I want to do is fill in Amount (B9 Yellow box) and Size (B10 Orange box) which then cross references the information and gives me the total.

So, Amount = 2000, Size = A4 Double, Total should = 3


If I can get this working, I can add in other charts using the same formula and hopefully make our quoting system a lot easier and quicker :)

[Matblack]

Like this?

http://www.bettersolutions.com/excel/EDH113/LN420111612.htm

MB

[Dymetrie]

Alternatively a nice long 'IF'/'AND'/'OR' formula would do the job...

[Desmo]

Seen that link MB but couldn't get it working :/

[kaiowas]

=OFFSET(A1,MATCH(B9,A2:A5,1),MATCH(B10,B1:E1,1))

[Dymetrie]

=OFFSET(A1,MATCH(B9,A2:A5,1),MATCH(B10,B1:E1,1))

Keep getting either errors or incorrect results on that one...

Could just be Excel 2007 though....

[Desmo]

Excellent, looks like Phil's is working great :cool:

Not sure what I was doing wrong earlier. Just need to expand it now....cheers Phil :)

[Dymetrie]

Yup, after chatting to young Desmo. He changed the '1's to '0's and doing the same on mine made it work (under 2007 and 2000).

Fun Fun Fun

[kaiowas]

Oops, I knew it should have been '0'. No idea why I typed '1'

[Dymetrie]

Oops, I knew it should have been '0'. No idea why I typed '1'

YOU *******! YOU MADE ME DOUBT THE POWER OF OFFICE 2007!!!!

;D