Need help in putting up a formula in the Cell highlighted in Yellow. The orange cells are manually entered and the ones is Gray is the lookup range. So when i enter the orange cells the Yellow cell with a formula should show the Percentile from the Gray table by looking up the salary entered in the Orange cell and comparing the Currency, Desig, Level and give the Percentile. I tried combination of Vlookup, Index and Match but unable to figure out.
10.1 KB Views: 9