an alternative

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.
Who is Participating?
NBVCConnect With a Mentor Commented:
Possibly an alternative for 2003?

Saqib Husain, SyedConnect With a Mentor EngineerCommented:
If you have 2007 or later you can try

SvgmassiveAuthor Commented:
no some folks still have 2003
Saqib Husain, SyedEngineerCommented:
Then try using two dummy columns with the two address functions


and then something like


You can hide the dummy columns.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.