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.
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.