Excel formulas create
<p>Hello I have a problem with excel formulas <strong><code>=IFERROR(OR(IF(C2=INDEX(data!A2:A70126;MATCH(C3;data!B2:B70126;0));TRUE;FALSE);IF(C2=INDEX(data!A2:A70126;MATCH(C3;data!B2:B70126;0));TRUE;FALSE));FALSE)</code></strong></p>

<p>I have a column A where is contain data for cell C2 and column B where is data for cell C3. But I have a problem when I search a match. for example:</p>

<p><strong>Column A (cell C2)  -----  Column B (cell C3)</strong></p>

<p>551-021  ---------------------              1055102000001</p>

<p>551-021    ---------------------          1055102000002</p>

<p>551-021    ---------------------         1055102000003</p>

<p>551-021    ---------------------          1055102000004</p>

<p>010.551-025  ---------------       1055102000000</p>

<p>010.551-025  ---------------    1055102000001</p>

<p>010.551-025    ---------------  1055102000002</p>

<p>010.551-025  ---------------    1055102000003</p>

<p>The problem is that for a different value in column "A" and cell "C2" with the same code from column "B", and the cells "C3"</p>

<p>When i search match 010.551-025 and 1055102000002 show me FALSE but for 551-021 and 1055102000002 show me TRUE. Do you know how can I repair it?</p>

<p>Thank you</p>