If then else with 3 criteria's

[rcb007]

I am trying to create a formula which would allow for 3 different cases.
If the target cell is blank, it would return as blank.
If the target cell has a Keyword [Existing Utility], I would use a wild card to search for it (Ex*Util*)
If the target cell does not have any of the above to run a match and index.

=IF(A3="","",(IF(ISNUMBER(FIND("Ex*Util*",A3)),(INDEX(E2:E6,MATCH(A3,D2:D6))),(INDEX(H2:H6,MATCH(A3,G2:G6))))))

Thank you for any help.

 

[Fluff]

Try changing FIND to SEARCH

 

[rcb007]

Try changing FIND to SEARCH

Thank you for the idea of the swap. It seemed to get a better result than that of before. Am I going to need individual names instead of using a wild card to collect some of these values?

=IF(A2="","",(IF(ISNUMBER(SEARCH("Ex*Util*",A2)),(INDEX($E$2:$E$10,MATCH(A2,$D$2:$D$10))),(INDEX($H$2:$H$10,MATCH(A2,$G$2:$G$10))))))

 

[Fluff]

Am I going to need individual names instead of using a wild card to collect some of these values?

That depends on what you are trying to do.

 

[rcb007]

Within the D Column, I am wanting to use a wildcard selection if possible. Within the D Column are some sample Names. Depending on the circumstance, there could be some or all of those names, but I do need them to pull from that side of the table.

 

[Fluff]

Change the MATCH to XMATCH

 

[rcb007]

Gold. Thank you so much for your help Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.