Forum Discussion
How to code a set of numbers?
Hi, I am trying to use a key (see attachment , on column G &H ) to code a data set ( A through E) and place on a table (J though N). For example, the first row in the data set ( A through E) is 10,...
Below formula would do the trick:
=INDEX($H$3:$H$41;MATCH(A2;$G$3:$G$41;0);0)
Thank you Erol