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,22,29,31,33 to be coded as 3,1,0,1,0 ( using the key). I tried using the index and match function but with no luck. Please help.
Below formula would do the trick:
=INDEX($H$3:$H$41;MATCH(A2;$G$3:$G$41;0);0)
Thank you Erol
