I have a group of data with columns (.1-.4) and rows (AA-EE)
.1 .2 .3 .4 (.1 should line up above .8, .2 should go above .81, .3 should be above .82, and .4 should be above .83)
AA .8 .81 .82 .83
BB .7 .71 .72 .73
CC .6 .61 .62 .63
DD .5 .51 .52 .53
EE .4 .41 .42 .43
In Cell A1 I have a dropdown list of AA-EE (Row Headings)
In Cell B1 I have a dropdown list of .1-.4 (Column Headings)
How can I populate cell A2 with the number that matches the column and row heading and have it change by changing which input i select on the dropdown lists in A1, B1?
Example (I select DD in cell A1 and then select .3 in Cell B1, how can I get cell A2 to display .52??)
.1 .2 .3 .4 (.1 should line up above .8, .2 should go above .81, .3 should be above .82, and .4 should be above .83)
AA .8 .81 .82 .83
BB .7 .71 .72 .73
CC .6 .61 .62 .63
DD .5 .51 .52 .53
EE .4 .41 .42 .43
In Cell A1 I have a dropdown list of AA-EE (Row Headings)
In Cell B1 I have a dropdown list of .1-.4 (Column Headings)
How can I populate cell A2 with the number that matches the column and row heading and have it change by changing which input i select on the dropdown lists in A1, B1?
Example (I select DD in cell A1 and then select .3 in Cell B1, how can I get cell A2 to display .52??)
Last edited:
