Access table elements with numeric and alphanumeric indices

Question

Given the following table and two cells with content "green" and "2", how do I &nbsp;retrieve the value 50?Thanks&nbsp;&nbsp;&nbsp; &nbsp;1&nbsp; &nbsp;2&nbsp; &nbsp;3red&nbsp; 10&nbsp; 40&nbsp; 70green&nbsp; 20&nbsp; 50&nbsp; 80blue&nbsp; 30&nbsp; 60&nbsp; 90

subodh_tiwari_sktneer · Answer

karlbnapf&nbsp;If you have the following setup...&nbsp;You may try this...In G2=IFERROR(INDEX(B2:D4,MATCH(F2,A2:A4,0),MATCH(G1,B1:D1,0)),"")&nbsp;&nbsp;

twifoo · Answer

Another alternative would be:=VLOOKUP(F2,A2:D4,MATCH(G1,A1:D1,0),0)

Forum Discussion

Access table elements with numeric and alphanumeric indices

2 Replies

Resources

	1	2	3
red	10	40	70
green	20	50	80
blue	30	60	90