title: MS Excel: Find Last Occurrence of Specific Text Across Multiple Columns in a List and Return Matching Cell Value
body: <p>Using MS Excel (Not VBA), I would like a formula that searches across multiple Cells A2:D2 (and downward) to find and retrieve the last occurrence of a specific keyword found in a List &quot;Keywords (Find What)&quot; located in G2:G5.  If last occurrence of keyword is found in either cells A2:D2, then extract/return the matching value of the content in Cell E2.</p>
  <p>I've attempted to use this formula: =IFERROR(HLOOKUP(&quot;<em>&quot;&amp;G$5&amp;&quot;</em>&quot;,A2:D2,1,FALSE),&quot;&quot;), Unfortunately it does not allow to search from a list, nor does it find the last occurrence.</p>
  <p>See Illustration Example below for assistance:</p>
  <p><a href="https://i.stack.imgur.com/E5cLL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E5cLL.png" alt="enter image description here" /></a></p>