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.
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