My If OR formula does not work

[StormyGurl]

I am trying to create a formula that will give me the status of multi-lined Itemed Purchase Orders.
I have a formula in on Sheet “PO Stats”! starting in F2 (Not working to what I want to accomplish).
On Sheet “PO Stats”! I have a formula creating Unique PO Numbers form data on $A$2:$A$1001 and I want to know the status of the Whole PO using the criteria below.

1. = ”Pending”, if all of Column O (“PO Status”) on Sheet ‘Master’! or just 1 or more Line Item(s) has “Pending” and any combination of “Received”, “Cancelled”, “QC Hold”, “RMA”, “QC Accept”, or “Released”

2. = “Received”, if all of Column O (“PO Status”) on Sheet ‘Master’! or just 1 or more Line Item(s) has “Received” and any combination of “Cancelled”, “QC Hold”, “RMA”, “QC Accept”, or “Released”

3. = “Cancelled”, Only if all of Column O (“PO Status”) on Sheet ‘Master’! Line Item(s) has “Cancelled”

4. = “RMA”, if all of Column O (“PO Status”) on Sheet ‘Master’! or just 1 Line Item(s) has “RMA” and any combination of “Cancelled”, “QC Hold”, “QC Accept”, or “Released”

5. = “QC Hold”, if all of Column O (“PO Status”) on Sheet ‘Master’! or just 1 Line Item(s) has PO Statuses “QC Hold” and any combination of “Cancelled”, “RMA”, “QC Accept”, or “Released”

6. = “QC Accept”, if all of Column O (“PO Status”) on Sheet ‘Master’! or just 1 Line Item(s) has PO Statuses “QC Accept” and any combination of “Cancelled” or “Released”


7. = “Released”, Only if all of Column O (“PO Status”) on Sheet ‘Master’! Line Item(s) has “Cancelled”

Note: The results I are in column G of Sheet “PO Stats”!

Thank you.

[Bo_Ry]

Please try at F2 Press Ctrl+Shift+Enter

Please Login or Register  to view this content.

[FlameRetired]

StormyGurl how are you arriving at QC Hold in G5?

The only Line Item status that exist for PO# 1016057139 are
Released
Released
RMA


With this lookup row in N2:T2 and this formula array entered I get the same results as Bo_Ry.

	N	O	P	Q	R	S	T
2	Pending	QC Hold	Received	Cancelled	RMA	QC Accept	Released

Please Login or Register  to view this content.

[StormyGurl]

Thank you very much, Bo_RY & FlameRetired.

I have so much to learn and the logic in your formulas are easy to interpret.

StormyGurl

[FlameRetired]

You are very welcome. Glad to help.

Thank you for the feedback, kind words, added rep and marking your thread Solved.