Hello All
I have recieved help with another post on 'creating a list based on 2 spercific criteria' from an extremely helpful and patient member.
=IFERROR(INDEX('WO Shortages'!A$2:A$3000,AGGREGATE(15,6,(ROW('WO Shortages'!$B$2:$B$3000)-ROW('WO Shortages'!$B$2)+1)/((ISERROR(MATCH('WO Shortages'!$B$2:$B$3000,'WS Report'!$C$2:$C$3000,0)))*(ISERROR(MATCH('WO Shortages'!$E$2:$E$3000,'WS Report'!$M$2:$M$3000,0)))), ROWS(A$2:A2))),"")
The above formula is run and finds a matching item from WO Shortages in WS Report. A list on a new sheet is created excluding matches found based on the 2 existing criteria (which is matching row data).
I am hoping that a third requirement can be added into this formula. When searched it checks WO Shortages column X (quantity required) against WS Report column O (quantity issued). If the numbers matched it is excluded.
If the quantity issued is less than quantity required then it is listed.
Here is a link to the one drive file.
I have not added the above formula to this. It is placed in Results sheet A2, copies across to AS2 then copied down
Thanks
I have recieved help with another post on 'creating a list based on 2 spercific criteria' from an extremely helpful and patient member.
=IFERROR(INDEX('WO Shortages'!A$2:A$3000,AGGREGATE(15,6,(ROW('WO Shortages'!$B$2:$B$3000)-ROW('WO Shortages'!$B$2)+1)/((ISERROR(MATCH('WO Shortages'!$B$2:$B$3000,'WS Report'!$C$2:$C$3000,0)))*(ISERROR(MATCH('WO Shortages'!$E$2:$E$3000,'WS Report'!$M$2:$M$3000,0)))), ROWS(A$2:A2))),"")
The above formula is run and finds a matching item from WO Shortages in WS Report. A list on a new sheet is created excluding matches found based on the 2 existing criteria (which is matching row data).
I am hoping that a third requirement can be added into this formula. When searched it checks WO Shortages column X (quantity required) against WS Report column O (quantity issued). If the numbers matched it is excluded.
If the quantity issued is less than quantity required then it is listed.

Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.
Store photos and docs online. Access them from any PC, Mac or phone. Create and work together on Word, Excel or PowerPoint documents.
1drv.ms
Here is a link to the one drive file.
I have not added the above formula to this. It is placed in Results sheet A2, copies across to AS2 then copied down
Thanks