R
Ryan Poth
Gary,
One possible method, assuming your data looks like:
A B C D
---------
1| 3 7 9
2| 1 L L M
3| 5 L M H
4| 6 M H H
5|
6| 2 5 L
where A6 is the column sought and B6 is the row sought,
the formula to go into C6 is:
=OFFSET($A$1,MATCH(A6,$A$2:$A$4,1),MATCH(B6,$B$1:$D$1,1))
you may then enter subsequent row/column combinations in
row 7 onward and just copy the formula down.
Hope this helps.
Ryan
One possible method, assuming your data looks like:
A B C D
---------
1| 3 7 9
2| 1 L L M
3| 5 L M H
4| 6 M H H
5|
6| 2 5 L
where A6 is the column sought and B6 is the row sought,
the formula to go into C6 is:
=OFFSET($A$1,MATCH(A6,$A$2:$A$4,1),MATCH(B6,$B$1:$D$1,1))
you may then enter subsequent row/column combinations in
row 7 onward and just copy the formula down.
Hope this helps.
Ryan