Good afternoon,

I am using Excel 2007.

I have frustrated myself trying to make a sample formula work I received from a friend.

I need the formula to extract an order number (DOCNO) from Sheet2's column D to put its matching record on Sheet1 in column A when Sheet1's NIIN matches Sheet2's NIIN column.

I have attached a sample of the spreadsheet.

Here is the script sent me. I made multiple variations trying to make it work, but no success.

=INDEX(Sheet1!$C$2:$C$2493,MATCH(1,IF(Sheet1!$A$2:$A$2493=$B4,IF(Sheet1!$B$2:$B$2493=$C4,1)),0))

Thanks for any help.

Michael

Sample.xlsx