Spreadsheet: 270867d1381726295-need-formula-function-in-3rd-sheet-to-look_up-array-in-2-sheets-compare-data
Sheet: Sheet3

ROLL | NAME | PAPER2 | PAPER1
1004000024 | ROHIT SHARMA | 45.5
1004000137 | ROBIN SINGH | 103.5
1004000194 | VINOD KUMAR | 47
1004000196 | ANIL KUMAR | 93
1004000207 | RAHUL [NAME] | 99.75
1004000217 | AMAN KUMAR  ADGOTRA | 106.5
1004000218 | AMIT DOGRA | 70.75
1004000228 | ZAMINI  CHARAK | 120.25
1004000235 | [NAME] | 130
1004000255 | SACHIN  [NAME] | 89.75
1004000262 | RAJNEESH SHARMA | 98
1004000268 | MADHU SUMITA SHARMA | 97.5
1004000272 | RITU MALMOTRA | 100.25
1004000329 | AMIR HUSSAIN | 125.5
1004000376 | [NAME] | 98.75
1004000436 | AJAY KUMAR  *      O    Q I D | 101.25
1004000451 | NEELAM | 78.75
1004000468 | SONU KUMAR | 118.75
1004000476 | SANJEEV  KUMAR | 85
1004000483 | AAYUSHI | 117.75
1004000488 | VENIKA  SAINI | 119
1004000491 | JOGINDER KUMAR | 71
1004000493 | SATUTI  SHARMA | 120
1004000494 | SUDHIR  SINGH | 94.5
1004000525 | VINAI KUMAR  MISHRA | 116.75
1004000564 | ANOOP SINGH | 76
1004000590 | MOHIT KOUL  E | 98.5
1004000603 | SOVIT KUMAR | 91.75
1004000776 | BHARTI  DEVI T | 78
1004000798 | *TANZIN  SMINLEX | 73
1004000799 | PARAMJIT KUMAR | 106.5
1004000838 | DALJEET  KUMAR | 55
1004000839 | JASBIR  SINGH | 63
1004000860 | ABHIMANYU GOTAM | 100.5
1004000872 | RAVI RATTAN | 105.25
1004000878 | MUSHTAQ  AHMED | 66.75
1004000906 | UTTAM KUMAR  TIWARY | 121.5
1004000918 | AJAY KUMAR | 95.25
1004000951 | SHAIFU  KANGOTRA | 75.5
1004001087 | MOHIT GUPTA | 126.5
1004001092 | PRAVEEN  KUMAR [NAME] | 61.5
1004001195 | JAGRAMSINGH | 67.5
1004001196 | ISHAN JARAL | 102.75
1004001214 | LOVLEEN  KOUR | 78
1004001234 | ZULFKAR  ALI  CHOWDARY | 83.25
1004001239 | NITESH  SHARMA | 87.5
1004001244 | NAVEEN  SHARMA | 85.25
1004001295 | HARJIT  SINGH BALI | 118.25
1004001301 | SUNIL SHARMA      T | 128.25
1004001322 | SHILPA  PANGOTRA | 119
1004001330 | NITISH  KHAJURIA | 107.75
1004001377 | ANKIT GUPTA | 142.75
1004001404 | AMANDEEP SINGH | 114
1004001429 | RAMANDEEP KOUR | 57
1004001473 | NAVJOT  SINGH | 106
1004001500 | RAJINDER SINGH  MANHAS | 113
1004001509 | PRIYA BHARTI | 85
1004001510 | VINAY KUMAR | 87.75
1004001513 | [NAME] | 80.75
1004001515 | AAKASH  MALHOTRA | 106.25
1004001518 | LALIT SANDAL | 98
1004001539 | SUHAIB  AHMED BATT | 117
1004001602 | NAVDEEP  SHARMA | 108.75
1004001643 | RONICA  [NAME] | 112.75
1004001663 | MIHIR BARGOTRA | 100.75
1004001701 | DEEPAK  MAHAJAN | 111.75
1004001731 | ROSHI SHARMA | 103.25
1004001751 | VIKAS PATIAYA | 131.5
1004001759 | ASHISH  SANGRA | 100
1004001811 | RAHESH  SINGH | 96.5
1004001826 | VISHAL  KUMAR PURI | 123.25
1004001898 | VIKRAM  SINGH | 124.75
1004001910 | MUZAMIL  TARIQ | 109.5
1004001929 | ANKITA  GUPTA | 88.75
1004001948 | AKHIL BHARTI | 78.75
1004001976 | GOURAV | 75.25
1004002060 | SANJAY  KUMAR Z | 122
1004002189 | VIRENDER KUMAR  KHAJURIA Q | 120.5
1004002259 | UPMA BAKSHI | 93.5
1004002425 | ANUJ [NAME] | 122.5
1004002443 | SWARN SINGH | 105.25
1004002471 | RAMIKA  DALMOTRA | 58.75
1004002482 | SATISH  KUMAR | 97.25
1004002484 | DHEERAJ  SHARMA | 88.75
1004002500 | [NAME] | 108.5
1004002615 | SONAM BHARDWAJ | 80.75
1004002724 | NASIR [NAME] | 78.5
1004002851 | SIDDARTH KOUL | 105.75
1004002862 | MASQUEEN BABU | 75.5
1004002899 | KIRANDEE* KAUR  X    Q | 113.75
1004002907 | VISHWINDER  SINGH JAMWAL | 92.75
1004002966 | DARPAN  MALHOTRA | 95
1004002968 | ROHIT SINGH | 89.25
1004003000 | ARPAN MAHAJAN | 89.5