Dear All,

I need the help in following excel trick,

I have below table of Grade and Posts and grade wise % to each post, I want to find value using INDEX and match function in "Find Value
" column


Post
Grade DE DN SME DM
N1 8% 12% 0% 0%
N2 6% 10% 0% 0%
N3 5% 8% 0% 0%
N4 4% 7% 0% 0%

Sr No Grade Post Find Value
1 N1 DE
2 N4 DN
3 N3 SME
4 N2 DE
5 N2 DN
6 N3 DE
7 N4 DM
8 N1 DN


Pls help