Hello.
I'm trying to develop a table comparing probabilities of success from certain attributes. I basically, want to find out the probability of a success in the scenario (row selection) vs (Column Selection), which is in the table attached. For example, Z vs X is 40%, how would I make it so that my Excel sheet displays this automatically when I select Z as choice 1, and X as choice 2?
Some help would be greatly appreciated.
Thanks!
Last edited by iamvoodoo; 10-27-2013 at 01:04 AM.
Hi and welcome to the forum
Give this a shot...
=INDEX($A$1:$E$5,MATCH($B$8,$A$1:$A$5,0),MATCH($C$8,$A$1:$E$1,0))
Also, your profile says 2003, but your upload indicates 2007 or later. Members often formulate dependant on the version you have, so please amend your profile
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks