Spreadsheet: 120342d1315222706-lookup-values-from-two-different-columns-in-a-table-matrix-excelhelp
Sheet: Emp Data

 |  | Total PR Score | 2013 | 2014 | As on 01/01/13 | As on 01/01/14 | TOTAL | As on1/1/13 | Rev
 |  | 12 |  |  |  |  |  | 7.638356164383562 | 341364.24 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 12 |  |  |  |  |  | 6.315068493150685 | 487921.2 |  |  | Year 2013 |  |  |  | Year 2014
 |  | 10 |  |  |  |  |  | 7.13972602739726 | 1016381.76 |  | Years | 10 OR 9 | 8 OR 7 | 6 0R 5 0R 4 | 3 OR 2 | 10 OR 9 | 8 OR 7 | 6 0R 5 0R 4 | 3 OR 2 | <<This is PR Score
 |  | 10 |  |  |  |  |  | 5.528767123287671 | 278940.12 |  | 0 | N/A | N/A | N/A | 5 | N/A | N/A | N/A | 5
 |  | 10 |  |  |  |  |  | 6.065753424657534 | 224315.52 |  | 3 | 12 | 10 | 5 | 5 | 24 | 20 | 10 | 10
 |  | 9 |  |  |  |  |  | 4.953424657534247 | 377441.04 |  | 4 | 16 | 13 | 6 | 5 | 32 | 27 | 14 | 10
 |  | 9 |  |  |  |  |  | 7.082191780821918 | 643196.16 |  | 5 | 20 | 16 | 7 | 5 | 40 | 34 | 18 | 10
 |  | 9 |  |  |  |  |  | 5.547945205479452 | 604598.3999999999 |  | 6 | 24 | 20 | 10 | 5 | 48 | 40 | 20 | 10
 |  | 9 |  |  |  |  |  | 5.731506849315068 | 277200 |  | 7 | 28 | 23 | 12 | 5 | 56 | 47 | 23 | 10
 |  | 9 |  |  |  |  |  | 7.676712328767123 | 487921.2 |  | 8 | 32 | 26 | 13 | 5 | 64 | 54 | 27 | 10
 |  | 9 |  |  |  |  |  | 9.747945205479452 | 960852 |  | 9 | 36 | 30 | 15 | 5 | 72 | 60 | 30 | 10
 |  | 9 |  |  |  |  |  | 7.81917808219178 | 806127.96
 |  | 9 |  |  |  |  |  | 7.002739726027397 | 256800.12
 |  | 9 |  |  |  |  |  | 7.695890410958904 | 224315.52 |  | Lookup Value In Col I2
 |  | 8 |  |  |  |  |  | 7.504109589041096 | 655447.5599999999 |  | If Less than 3 then I2 otherwise Round of I2, 0 decimal places
 |  | 8 |  |  |  |  |  | 4.756164383561644 | 1299999.96 |  | This is the formula I have
 |  | 8 |  |  |  |  |  | 10.24931506849315 | 266222.4 |  | =VLOOKUP(IF(I3<3,I3,ROUND(I3,0)),DataTable,IF(I need help here)
 |  | 8 |  |  |  |  |  | 6.66027397260274 | 643196.16
 |  | 8 |  |  |  |  |  | 6.813698630136987 | 1047252
 |  | 8 |  |  |  |  |  | 6.189041095890411 | 1890000.6 |  | I need help here to build formula for Col D (2013) and Col E (2014)
 |  | 8 |  |  |  |  |  | 7.920547945205479 | 1550885.28 |  | The value in Column I to be checked in DataTable with range name Years
 |  | 8 |  |  |  |  |  | 6.591780821917808 | 276971.4 |  | The Value in Column C to be checked with DataTable PR Score
 |  | 8 |  |  |  |  |  | 8.224657534246575 | 303023.4 |  | If [NAME] or 9  then give corresponding values according to the years, if between 8 or 7 etc etc
 |  | 8 |  |  |  |  |  | 10.03013698630137 | 345704.28
 |  | 8 |  |  |  |  |  | 10.10958904109589 | 1047252 |  | Range Names Defined
 |  | 8 |  |  |  |  |  | 8.232876712328768 | 575808 |  | Years | L5:l12
 |  | 8 |  |  |  |  |  | 4.684931506849315 | 415502.76 |  | DataTable | [NAME]:T12
 |  | 8 |  |  |  |  |  | 7.408219178082192 | 639999.96
 |  | 7 |  |  |  |  |  | 7.484931506849315 | 368524.8
 |  | 7 |  |  |  |  |  | 4.876712328767123 | 224315.52
 |  | 7 |  |  |  |  |  | 5.720547945205479 | 604598.3999999999
 |  | 7 |  |  |  |  |  | 6.515068493150685 | 224315.52
 |  | 7 |  |  |  |  |  | 7.342465753424658 | 1149999.96
 |  | 7 |  |  |  |  |  | 6.331506849315068 | 643196.16
 |  | 7 |  |  |  |  |  | 3.917808219178082 | 403859.16
 |  | 7 |  |  |  |  |  | 4.780821917808219 | 403857.6
 |  | 7 |  |  |  |  |  | 7.849315068493151 | 487921.2
 |  | 7 |  |  |  |  |  | 7.758904109589041 | 88674.48
 |  | 7 |  |  |  |  |  | 7.424657534246576 | 88674.48
 |  | 7 |  |  |  |  |  | 6.18082191780822 | 997379.04
 |  | 7 |  |  |  |  |  | 7.983561643835617 | 1003200.72
 |  | 7 |  |  |  |  |  | 6.084931506849315 | 356942.88
 |  | 6 |  |  |  |  |  | 6.391780821917808 | 228671.16
 |  | 6 |  |  |  |  |  | 7.504109589041096 | 387861.12
 |  | 6 |  |  |  |  |  | 5.526027397260274 | 224315.52
 |  | 6 |  |  |  |  |  | 5.175342465753425 | 222480
 |  | 6 |  |  |  |  |  | 6.43013698630137 | 806127.96
 |  | 6 |  |  |  |  |  | 5.087671232876712 | 377441.04
 |  | 6 |  |  |  |  |  | 4.838356164383562 | 296392.8
 |  | 6 |  |  |  |  |  | 5.912328767123288 | 439522.92
 |  | 6 |  |  |  |  |  | 4.473972602739726 | 403857.6
 |  | 5 |  |  |  |  |  | 4.128767123287671 | 377441.04
 |  | 5 |  |  |  |  |  | 4.608219178082192 | 353960.52
 |  | 5 |  |  |  |  |  | 7.424657534246576 | 531826.3200000001
 |  | 5 |  |  |  |  |  | 6.947945205479452 | 424054.92
 |  | 5 |  |  |  |  |  | 3.994520547945205 | 332357.28
 |  | 5 |  |  |  |  |  | 6.947945205479452 | 179301.24
 |  | 5 |  |  |  |  |  | 4.947945205479452 | 134724
 |  | 5 |  |  |  |  |  | 10.09315068493151 | 399236.04
 |  | 5 |  |  |  |  |  | 4.128767123287671 | 510255.96
 |  | 5 |  |  |  |  |  | 5.090410958904109 | 37406.28
 |  | 5 |  |  |  |  |  | 5.090410958904109 | 38902.56
 |  | 5 |  |  |  |  |  | 9.342465753424657 | 224315.52
 |  | 5 |  |  |  |  |  | 7.753424657534246 | 470765.4
 |  | 5 |  |  |  |  |  | 8.509589041095891 | 235142.4
 |  | 5 |  |  |  |  |  | 6.334246575342465 | 332694.24
 |  | 5 |  |  |  |  |  | 5.090410958904109 | 37406.28
 |  | 5 |  |  |  |  |  | 6.334246575342465 | 64262.28
 |  | 5 |  |  |  |  |  | 5.090410958904109 | 37406.28
 |  | 5 |  |  |  |  |  | 2.978082191780822 | 575808
 |  | 4 |  |  |  |  |  | 3.936986301369863 | 604598.3999999999
 |  | 4 |  |  |  |  |  | 4.953424657534247 | 353960.52
 |  | 4 |  |  |  |  |  | 5.567123287671233 | 377442.24
 |  | 4 |  |  |  |  |  | 2.93972602739726 | 575808
 |  | 4 |  |  |  |  |  | 3.4 | 520165.8
 |  | 4 |  |  |  |  |  | 6.424657534246576 | 167258.28
 |  | 4 |  |  |  |  |  | 5.126027397260274 | 247200.12
 |  | 4 |  |  |  |  |  | 5.271232876712329 | 353960.52
 |  | 4 |  |  |  |  |  | 5.50958904109589 | 228671.16
 |  | 4 |  |  |  |  |  | 5.336986301369863 | 179301.24
 |  | 4 |  |  |  |  |  | 6.810958904109589 | 629680.8
 |  | 4 |  |  |  |  |  | 7.158904109589041 | 575397.96
 |  | 4 |  |  |  |  |  | 5.547945205479452 | 296640
 |  | 4 |  |  |  |  |  | 4.358904109589041 | 134724
 |  | 3 |  |  |  |  |  | 5.126027397260274 | 353960.52
 |  | 3 |  |  |  |  |  | 4.167123287671233 | 543840
 |  | 3 |  |  |  |  |  | 4.684931506849315 | 149188.56
 |  | 3 |  |  |  |  |  | 5.336986301369863 | 253380.96
 |  | 3 |  |  |  |  |  | 5.893150684931507 | 179301.24
 |  | 3 |  |  |  |  |  | 6.846575342465753 | 575397.96
 |  | 3 |  |  |  |  |  | 3.265753424657534 | 510255.84
 |  | 2 |  |  |  |  |  | 2.556164383561644 | 224316
 |  | 2 |  |  |  |  |  | 2.589041095890411 | 1260000
 |  | 2 |  |  |  |  |  | 3.380821917808219 | 271920
 |  | 2 |  |  |  |  |  | 3.150684931506849 | 510255.84
 |  | 2 |  |  |  |  |  | 1.578082191780822 | 173040
 |  | 2 |  |  |  |  |  | 1.884931506849315 | 173040
 |  | 2 |  |  |  |  |  | 2.153424657534246 | 495394.32
 |  | 2 |  |  |  |  |  | 4.33972602739726 | 247200
 |  | 2 |  |  |  |  |  | 4.33972602739726 | 247200
 |  | 2 |  |  |  |  |  | 5.336986301369863 | 253380.96
 |  | 2 |  |  |  |  |  | 3.342465753424658 | 247200
 |  | 1 |  |  |  |  |  | 5.336986301369863 | 253380.96
 |  | 1 |  |  |  |  |  | 2.03013698630137 | 432000
 |  | 1 |  |  |  |  |  | 4.33972602739726 | 247200
 |  | 1 |  |  |  |  |  | 3.342465753424658 | 247200
 |  | 1 |  |  |  |  |  | 3.342465753424658 | 247200
 |  | 1 |  |  |  |  |  | 1.515068493150685 | 495393.96
 |  | 1 |  |  |  |  |  | 1.328767123287671
 |  | 0 |  |  |  |  |  | 2.298630136986302 | 193557
 |  | 0 |  |  |  |  |  | 1.405479452054795 | 173040
 |  | 0 |  |  |  |  |  | 1.328767123287671
 |  | 0 |  |  |  |  |  | 2.298630136986302 | 193557
 |  | 0 |  |  |  |  |  | 2.298630136986302 | 193557
 |  | 0 |  |  |  |  |  | 1.515068493150685 | 950000.04
 |  | 0 |  |  |  |  |  | 2.298630136986302 | 193557
 |  | 0 |  |  |  |  |  | 2.134246575342466 | 377441.04
 |  | 0 |  |  |  |  |  | 4.087671232876712 | 4629240
 |  | 0 |  |  |  |  |  | 2.301369863013699 | 540000
 |  | 0 |  |  |  |  |  | 2.287671232876712 | 193557
 |  | 0