INDEX/MATCH to return matched value in table
<p>I've been having an issue trying to get Excel to return the value in a cell that is immediately to the right of the matched value in a table. I have been trying to use the following formula, but it doesn't appear to like tables, and can't seem to work out how to reference a cell relative to the matched cell (not just a single column reference).</p>

<pre><code>{=IF(ISERROR(INDEX($K$18:$L$42,SMALL(IF($K$18:$K$42=$B$2,ROW($K$18:$K$42)-17),ROW(1:1)),2)),"",INDEX($K$18:$L$42,SMALL(IF($K$18:$K$42=$B$2,ROW($K$18:$K$42)-17),ROW(1:1)),2))}
</code></pre>

<p>Appreciate any help/guidance on this!</p>