Excel - Find a value in an array and return the value of the cell next to it
<p>I have a table in which I want to search for &quot;Item&quot; in the whole Array of E1:X100 and return the value next to the match in the &quot;Output&quot; row.</p>
<p>As an example: I want to search for the Item &quot;AC06&quot; (marked yellow) in the whole rest of the sheet - find it in I8 and output the value in the cell next to it (marked green) to the cell C13.</p>
<p><a href="https://i.stack.imgur.com/EWvLC.png" rel="nofollow noreferrer">See Example Table here</a></p>
<p>I experimented with an index match without success. One way to solve it would be of course to copy all of the Items and Descriptions under each other and do a Vlookup - this, however, is not the real Solution we need.</p>