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
Bookmarks