I have this issue:


I received data in this format

ID JAN FEB MAR APR etc.
33 2002 7 8 9 9
33 2003 5 6 7 8
33 2004 4 5 7 8
34 2003 5 6 7 8
34 2004 4 5 7 3


Basically I need to have a lookup towards the ID and then it should check for the particular month in a particular year, how could this be done?

The problem is that from the whole data set of three years sometimes only one or two years are available.


Thank you!