Concatenate three IF formulas in one

[YusufAkhtar]

Out of all a two client has specific deadlines which is


for client ABC= if any work recevied between Thursday to Wednesday it should be completed on every Wednesday
For Client EFG= any work recevied between 21st - 20th of the month = the work sould be completed on 20 th of every month


For all other clients, the work recevied between monday to wed= should be completed till friday AND work recevied from thursday to sunday should be completed till tuesday.






I have made the formula for all three but i want three in one cell, can you please help me in getting all three formulaes under one cell?




For client ABC : =IFERROR(IF(AND(LEFT(D3,3)="ABC",LEFT(E3,4)="Payr"),VLOOKUP(G3,$G$8:$H$9,2,0)," ")," ")
For Client EFG: =IFERROR(IF(AND(LEFT(D4,3)="AOC",LEFT(E4,4)="Payr"),VLOOKUP(G4,$N$8:$O$9,2,0)," ")," ")
For all other clients = (IF(LEFT(E2,4)="Payr",VLOOKUP(G2,'$O$3:$Q$311,3,0)


To get the above formula:


Column D has the list of client names
Column E has the list of sub-types
Column G has the recevied date

 

[Joyner]

Hello, maybe:

=IFERROR(IF(OR(LEFT(E2,4)="Payr",LEFT(E3,4)="Payr",LEFT(E4,4)="Payr"),IF(LEFT(D3,3)="ABC",VLOOKUP(G3,$G$8:$H$9,2,0),IF(LEFT(D4,3)="AOC",VLOOKUP(G4,$N$8:$O$9,2,0),VLOOKUP(G2,$O$3:$Q$311,3,0))),""),"")