Mapping

Hi All,

I have this table which I have to map. It has a huge mapping logic. I would like to know is what can I use for this - excel lookup, macros or access. I am attaching the mapping table. Also the logic is :

Search MII report (both GL and Sub-Account) on the basis of Sunny GL and sub-account. If matches, return the value which corresponds to the LAPGL account, which in turn will return the BA/PC required and TP required.
e.g. search MII 100005 and 0000 and match it with 100005 and 0000 in Sunny and return 0010000000 and this in turn will return N/Y in BA/PC and N/Y in TP. Could someone help me out in this. That would be really helpful.

Thanks a lot.

Regards,
Indira