Hi All,
wondering anyone can help me.
I have a table. Column A contain month, 1 to 12. and Column B, C, D, E and F contain Department headings. What i am looking for is is to use formula to pull value from table using multiple criteria as shown below.
Mnth TB TD TC LM FSM
1 a1 b1 c1 d1 e1
2 a2 b2 c2 d2 e2
3 a3 b3 c3 d3 e3
4 a4 b4 c4 d4 e4
5 a5 b5 c5 d5 e5
6 a6 b6 c6 d6 e6
7 a7 b7 c7 d7 e7
8 a8 b8 c8 d8 e8
9 a9 b9 c9 d9 e9
10 a10 b10 c10 d10 e10
11 a11 b11 c11 d11 e11
12 a12 b12 c12 d12 e12
Requirement:
Select Department Select Month Return Value
TC 3 c3
The file is also attached for your reference. Any help will be greatly appreciated
Regards
Shido
Bookmarks