Find exact match of text in excel array (from another sheet) and display a specific cell value from the same row
<p>I am comparing two separate spreadsheets.  I need to write a formula that will find the exact text in the other sheet (if it exists), and will then display a value in the corresponding row only 5 cells over.</p>

<p>I have tried various iterations of Index Match to no avail.  Any help would be greatly appreciated.  The sheets are formatted roughly the same way.  </p>

<p>Let me know if I am not being clear enough.</p>

<p>I used this formula, but it is displaying data regardless of whether or not the cell data matches data in the other sheet's row.</p>

<p>=IF(ISERROR(INDEX(product_performance!$A$2:$E$850,SMALL(IF(product_performance!$A$2:$A$345050=$A$13,ROW(product_performance!$A$2:$A$3450)),ROW(1:1)),8)),"",INDEX(product_performance!$A$2:$H$3450,SMALL(IF(product_performance!$A$2:$A$3450=$A$13,ROW(product_performance!$A$2:$A$3450)),ROW(1:1)),8))</p>