Help with a Nested IF/OR Formula

[NE-WS]

Hello!

I'm trying to build a formula that does the following:

If AG="Billable" then return AG -OR-
If AG="Not Billable" then UNBILLABLE -OR-
If AF="Unspecified Coverage" AND AB <> "Weak Match" then UNBILLABLE
If none of above are true, then VLOOKUP Against Excluded Payers and return value

I've managed to get the formula to function as expected for all except the first condition - here is what I've created:

=IF(OR(AG20="Not Billable",AND(AF20="Unspecified Coverage",AB20<>"Weak Match")),"Unbillable",IFERROR(VLOOKUP(AD20,'Excluded Payers'!A:C, 3, FALSE),AB20))

I'm not able to figure out how to modify the formula to consider the first condition.

Any assistance is appreciated!

Nate

[#2 · Accepted solution]

@NE-WS 

=IF(AG20="Billable",AG20,IF(OR(AG20="Not Billable",AND(AF20="Unspecified Coverage",AB20<>"Weak Match")),"Unbillable",IFERROR(VLOOKUP(AD20,'Excluded Payers'!A:C, 3, FALSE),AB20)))

Does this return the expected result?

[#3]

This was PERFECT - thank you so much!!