I need a formula that will look up 2 values in table below and tell me what % it is.....ie if I"m looking in Column A for 147 and then 3 I want the formula to tell me its 100%
A B C D E F
1 120% 110% 100% 90% 85%
2 150 5 4 3 2 1
3 149 5 4 3 2 1
4 148 5 4 3 2 1
5 147 5 4 3 2 1
6 146 4 3 2 1 0
7 145 4 3 2 1 0
8 144 4 3 2 1 0
9 143 4 3 2 1 0
10 142 3 2 1 0 0
11 141 3 2 1 0 0
12 140 3 2 1 0 0
Bookmarks