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.
Hi Joey,
Please type the formula in Cell C1″ =INDEX(A11:D14,MATCH(A1,A11:A14,0),MATCH(B1,A11:D11,0))” without quotes.
Tried that came up with an error. I think it must be close though
Hi Joey. The above stated formula is working properly. Kindly check the same at your end. if there is no luck, you can mail the file to EXCELROCKER@YMAIL.COM . I shall check and revert
Hi Joey & Excelrocker,
Thanks for your contribution on ExcelQnA.com
Just a request. Please avoid placing your email id/website on the posts. Exchanging files should be done through file sharing tools like GoogleDrive. And please place solutions on the posts itself so as to benefit other viewers too.
Thanks for your patronage,
Admin | ExcelQnA.com
After looking into the sheet more the formula you gave was correct it was an error I had elsewhere causing the problem.
just to add some more complexity to it is there a way to add a third part to the formula to include a third variable?
yes you can add one more variable. Please define your question clearly with instance.
