What formula do I use for picking values from a matrix? (Excel 2003)
I have set up A1 as a drop down list of the items on the left in grey. I have set up B1 as a drop down list of items in grey across the top of the table. how do I/what formula do I use so that when the boxes are selected C1 will show the number from the table. for example A1 has 4 picked, B1 has 0 picked I want C1 to show up with 8810? any help would be great.