Using results of If-Then statement in true clause

I am trying to use the value that returned true later on in an equation but am finding it difficult, if not impossible, to do so. This is what my formula looks like:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"Application","Account","Machine"}, H5))), INDEX(Sheet1!N$2:N$7, MATCH(<term that made the SEARCH function true,Sheet1!M$2:M$7,0)), "")

I am trying to search a cell for a series of words, and if one of those words is found, use that word in an INDEX-MATCH search. Is there a way to do this or do I need to break my work up into two steps?