. A B C D E
1 Jan Feb Mar Apr
2 Galle JG FG MG AG
3 Matara JM FM MM AM
4 Kalutara JK FK MK AK
5 Panadura JP FP MP AP
6 Colombo JC FC MC AC
7
8 City Month
9 Kalutara Mar MK
When I type 'Kalutara' in A9 and 'Mar' in B9 I should get the answer as MK in cell E9
'Colombo' " " 'Feb' B9 " " " FC in cell E9 by refering the above table
can we use MATCH & INDEX or VLOOKUP & HLOOKUP
What is the formula I should write in cell E9 to get this done?
Bookmarks