<div>
no some folks still have 2003
</div>


<div>
Then try using two dummy columns with the two address functions<br />
<br />
=ADDRESS(MATCH(EMPLOY_EE,E<wbr />MP_NAMES,0<wbr />),1)<br />
=ADDRESS(MATCH(EMPLOY_EE,S<wbr />UPV_EMP_CO<wbr />L,0),COLUM<wbr />N(SUPV_EMP<wbr />_COL))<br />
<br />
and then something like<br />
<br />
=if(iserror(col1),if(iserr<wbr />or(col2),&quot;<wbr />&quot;,col2),co<wbr />l1)<br />
<br />
You can hide the dummy columns.
</div>


Then try using two dummy columns with the two address functions

=ADDRESS(MATCH(EMPLOY_EE,EMP_NAMES,0),1)
=ADDRESS(MATCH(EMPLOY_EE,SUPV_EMP_COL,0),COLUMN(SUPV_EMP_COL))

and then something like

=if(iserror(col1),if(iserror(col2),"",col2),col1)

You can hide the dummy columns.

<div>
<div class="content wysiwyg-content">
i am using the formula below to check if a name exits in two tables if ,the problem is that the function checks the columns four times two with the count if and the other to get the address on a large table this can affect performance.I need to only check the table once and return a blank if the name does not exist.<br />
=IF(COUNTIF(EMP_NAMES,EMPL<wbr />OY_EE),ADD<wbr />RESS(MATCH<wbr />(EMPLOY_EE<wbr />,EMP_NAMES<wbr />,0),1),IF(<wbr />COUNTIF(SU<wbr />PV_EMP_COL<wbr />,EMPLOY_EE<wbr />),ADDRESS(<wbr />MATCH(EMPL<wbr />OY_EE,SUPV<wbr />_EMP_COL,0<wbr />),COLUMN(S<wbr />UPV_EMP_CO<wbr />L)),&quot;&quot;))
</div>
</div>


i am using the formula below to check if a name exits in two tables if ,the problem is that the function checks the columns four times two with the count if and the other to get the address on a large table this can affect performance.I need to only check the table once and return a blank if the name does not exist.
=IF(COUNTIF(EMP_NAMES,EMPLOY_EE),ADDRESS(MATCH(EMPLOY_EE,EMP_NAMES,0),1),IF(COUNTIF(SUPV_EMP_COL,EMPLOY_EE),ADDRESS(MATCH(EMPLOY_EE,SUPV_EMP_COL,0),COLUMN(SUPV_EMP_COL)),""))

an alternative

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.