Spreadsheet: 44369d1242954793-formula-required-to-search-multiple-parameters-and-return-value-fo-analysis
Sheet: Sheet1

 | 2009-05-21 00:00:00 |  |  | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 |  |  | 2009-05-20 00:00:00
 | SYMBOL | INSTRUMENT | EXP_DATE | OPEN_INT* | OPEN_INT* | DIFFERENCE |  | SYMBOL | INSTRUMENT | EXPIRY_DT | OPEN_INT
 | BANKNIFTY | FUTIDX | 28/05/2009 | WANT A FORMULA HERE | 506600 | #N/A |  | BANKNIFTY | FUTIDX | 2009-05-28 00:00:00 | 569600
 | BANKNIFTY | FUTIDX | 25/06/2009 |  | 49300 |  |  | BANKNIFTY | FUTIDX | 2009-06-25 00:00:00 | 49300
 | BANKNIFTY | FUTIDX | 30/07/2009 |  | 600 |  |  | BANKNIFTY | FUTIDX | 2009-07-30 00:00:00 | 550
 | CNXIT | FUTIDX | 28/05/2009 |  | 5100 |  |  | CNX100 | FUTIDX | 2009-05-28 00:00:00 | 0
 | MINIFTY | FUTIDX | 28/05/2009 |  | 961000 |  |  | CNX100 | FUTIDX | 2009-06-25 00:00:00 | 0
 | MINIFTY | FUTIDX | 25/06/2009 |  | 195960 |  |  | CNX100 | FUTIDX | 2009-07-30 00:00:00 | 0
 | MINIFTY | FUTIDX | 30/07/2009 |  | 10820 |  |  | CNXIT | FUTIDX | 2009-05-28 00:00:00 | 4700
 | NIFTY | FUTIDX | 28/05/2009 |  | 33514550 |  |  | CNXIT | FUTIDX | 2009-06-25 00:00:00 | 0
 | NIFTY | FUTIDX | 25/06/2009 |  | 4205150 |  |  | CNXIT | FUTIDX | 2009-07-30 00:00:00 | 0
Looking for a formula in column 'E'. I am trying to calculate the Open Interest Percentage Difference between y'day and today.  I am unable to achieve this by [NAME]. I want to compare Symbol, Instrument & Exp_date fields with y'days report (Col I-L) and | NIFTY | FUTIDX | 30/07/2009 |  | 66250 |  |  | DEFTY | FUTIDX | 2009-05-28 00:00:00 | 0
 | 3IINFOTECH | FUTSTK | 28/05/2009 |  | 4309200 |  |  | DEFTY | FUTIDX | 2009-06-25 00:00:00 | 0
 | 3IINFOTECH | FUTSTK | 25/06/2009 |  | 43200 |  |  | DEFTY | FUTIDX | 2009-07-30 00:00:00 | 0
 | ABAN | FUTSTK | 28/05/2009 |  | 1584400 |  |  | JUNIOR | FUTIDX | 2009-05-28 00:00:00 | 800
 | ABAN | FUTSTK | 25/06/2009 |  | 182000 |  |  | JUNIOR | FUTIDX | 2009-06-25 00:00:00 | 0
 | ABAN | FUTSTK | 30/07/2009 |  | 1200 |  |  | JUNIOR | FUTIDX | 2009-07-30 00:00:00 | 0
 | ABB | FUTSTK | 28/05/2009 |  | 1307500 |  |  | MINIFTY | FUTIDX | 2009-05-28 00:00:00 | 922200
 | ABB | FUTSTK | 25/06/2009 |  | 188500 |  |  | MINIFTY | FUTIDX | 2009-06-25 00:00:00 | 187600
 | ABIRLANUVO | FUTSTK | 28/05/2009 |  | 127600 |  |  | MINIFTY | FUTIDX | 2009-07-30 00:00:00 | 9580
 | ABIRLANUVO | FUTSTK | 25/06/2009 |  | 800 |  |  | NFTYMCAP50 | FUTIDX | 2009-05-28 00:00:00 | 300
 | ACC | FUTSTK | 28/05/2009 |  | 1336304 |  |  | NFTYMCAP50 | FUTIDX | 2009-06-25 00:00:00 | 0
 | ACC | FUTSTK | 25/06/2009 |  | 168448 |  |  | NFTYMCAP50 | FUTIDX | 2009-07-30 00:00:00 | 0
 | ADLABSFILM | FUTSTK | 28/05/2009 |  | 1544400 |  |  | NIFTY | FUTIDX | 2009-05-28 00:00:00 | 36391200
 | ADLABSFILM | FUTSTK | 25/06/2009 |  | 32400 |  |  | NIFTY | FUTIDX | 2009-06-25 00:00:00 | 2941500
 | ALBK | FUTSTK | 28/05/2009 |  | 1425900 |  |  | NIFTY | FUTIDX | 2009-07-30 00:00:00 | 66350
 | ALBK | FUTSTK | 25/06/2009 |  | 249900 |  |  | NSE10Y06 | FUTINT | 2009-05-28 00:00:00 | 0
 | ALOKTEXT | FUTSTK | 28/05/2009 |  | 15395640 |  |  | NSE10Y06 | FUTINT | 2009-06-25 00:00:00 | 0
 | ALOKTEXT | FUTSTK | 25/06/2009 |  | 3610776 |  |  | NSE10Y06 | FUTINT | 2009-07-30 00:00:00 | 0
 | AMBUJACEM | FUTSTK | 28/05/2009 |  | 7938700 |  |  | NSE10Y06 | FUTINT | 2009-09-24 00:00:00 | 0
 | AMBUJACEM | FUTSTK | 25/06/2009 |  | 453640 |  |  | NSE10Y06 | FUTINT | 2009-12-31 00:00:00 | 0
 | AMTEKAUTO | FUTSTK | 28/05/2009 |  | 456000 |  |  | NSE10Y06 | FUTINT | 2010-03-25 00:00:00 | 0
 | ANDHRABANK | FUTSTK | 28/05/2009 |  | 754400 |  |  | [NAME] | FUTINT | 2009-05-28 00:00:00 | 0
 | ANDHRABANK | FUTSTK | 25/06/2009 |  | 262200 |  |  | [NAME] | FUTINT | 2009-06-25 00:00:00 | 0
 | [NAME] | FUTSTK | 28/05/2009 |  | 238800 |  |  | [NAME] | FUTINT | 2009-07-30 00:00:00 | 0
 | APTECHT | FUTSTK | 28/05/2009 |  | 666900 |  |  | [NAME] | FUTINT | 2009-09-24 00:00:00 | 0
 | APTECHT | FUTSTK | 25/06/2009 |  | 195000 |  |  | [NAME] | FUTINT | 2009-12-31 00:00:00 | 0
 | ARVIND | FUTSTK | 28/05/2009 |  | 7258400 |  |  | [NAME] | FUTINT | 2010-03-25 00:00:00 | 0
 | ARVIND | FUTSTK | 25/06/2009 |  | 86000 |  |  | NSETB91D | FUTINT | 2009-05-28 00:00:00 | 0
 | ASHOKLEY | FUTSTK | 28/05/2009 |  | 5424400 |  |  | NSETB91D | FUTINT | 2009-06-25 00:00:00 | 0
 | ASHOKLEY | FUTSTK | 25/06/2009 |  | 95500 |  |  | NSETB91D | FUTINT | 2009-07-30 00:00:00 | 0
 | ASIANPAINT | FUTSTK | 28/05/2009 |  | 1600 |  |  | NSETB91D | FUTINT | 2009-09-24 00:00:00 | 0
 | AUROPHARMA | FUTSTK | 28/05/2009 |  | 467600 |  |  | NSETB91D | FUTINT | 2009-12-31 00:00:00 | 0
 | AUROPHARMA | FUTSTK | 25/06/2009 |  | 5600 |  |  | NSETB91D | FUTINT | 2010-03-25 00:00:00 | 0
 | AXISBANK | FUTSTK | 28/05/2009 |  | 3933900 |  |  | 3IINFOTECH | FUTSTK | 2009-05-28 00:00:00 | 4741200
 | AXISBANK | FUTSTK | 25/06/2009 |  | 408600 |  |  | 3IINFOTECH | FUTSTK | 2009-06-25 00:00:00 | 21600
 | BAJAJ-AUTO | FUTSTK | 28/05/2009 |  | 230400 |  |  | ABAN | FUTSTK | 2009-05-28 00:00:00 | 1568400
 | BAJAJ-AUTO | FUTSTK | 25/06/2009 |  | 7200 |  |  | ABAN | FUTSTK | 2009-06-25 00:00:00 | 157600
 | BAJAJHIND | FUTSTK | 28/05/2009 |  | 6059100 |  |  | ABAN | FUTSTK | 2009-07-30 00:00:00 | 800