For your first question, if I understand correctly, try:

=CHOOSE(SUMPRODUCT(--(ISNUMBER(SEARCH({"EDI","EDI","PN"},D2))),--(ISNUMBER(SEARCH({"EDI","ML","EDI"},E2))),{1,2,3}) +1,"","Julio","Meza","Angelina")

Note that if none of the combinations are found, it returns "".

For your second question, there's not really enough information to say. If
the above formula goes into cell C2, try replacing C2 in the formula below
w/the above formula and see what happens. But there is a lot to be said for
performing computations in stages to keep the formulae manageable. Monster
formulae can be a RPITA to debug or modify later on.


"pgarcia" wrote:

1. The below formula works great, however, I would like to do a little more
with it.

=IF(ISNUMBER(SEARCH("*EDI*",D2)),IF(ISNUMBER(SEARC H"*EDI*",F2)),"Julio","Mezar"))

Now, I have the following, how can I retune the correct name?
EDI EDI = Julio
EDI ML = Meza
PN EDI = Angelina

2. And can I add or combine the above formula to the below formula?

=INDEX('Cash App Schedule'!$B$2:$N$22,MATCH(C2,'Cash App
Schedule'!$A$2:$A$22,0),MATCH(E2,'Cash App Schedule'!$B$1:$N$1,0))