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 ...
Twifoo
Oct 19, 2019Silver Contributor
Another alternative would be:
=VLOOKUP(F2,A2:D4,
MATCH(G1,A1:D1,0),0)
=VLOOKUP(F2,A2:D4,
MATCH(G1,A1:D1,0),0)