Forum Discussion
karlbnapf
Oct 19, 2019Copper Contributor
Access table elements with numeric and alphanumeric indices
Given the following table and two cells with content "green" and "2", how do I retrieve the value 50? Thanks 1 2 3 red 10 40 70 green 20 50 80 blue ...
Subodh_Tiwari_sktneer
Oct 19, 2019Silver Contributor
If you have the following setup...
You may try this...
In G2
=IFERROR(INDEX(B2:D4,MATCH(F2,A2:A4,0),MATCH(G1,B1:D1,0)),"")