tatendamark
08-21-2018, 12:56 PM
Hi,
Please assist with returning names ("In Order" sheet - Column A) based on type of purchases placed. The names and type of purchases are located in "Not in Order" sheet. The order in which the purchases are placed in "Not in Order" sheet is incorrect. The correct order of the purchases is in "In Order" sheet.
The attached file is just a sample. There real file has over 100 purchases, some of them duplicate in terms of colour, size and type.
So for Cell A2 of "In Order" sheet, the formula should return "Mitsue Filice".
22751
Please assist with returning names ("In Order" sheet - Column A) based on type of purchases placed. The names and type of purchases are located in "Not in Order" sheet. The order in which the purchases are placed in "Not in Order" sheet is incorrect. The correct order of the purchases is in "In Order" sheet.
The attached file is just a sample. There real file has over 100 purchases, some of them duplicate in terms of colour, size and type.
So for Cell A2 of "In Order" sheet, the formula should return "Mitsue Filice".
22751