Dear All,
In our group, we manage people related data with a set of excel files.
Normal files extract the people related information (DOB, Emp ID etc.)
from 2 master files using the name as input to an INDEX-MATCH
combination. Problem is, it is working only in 99% cases. In some
stray occasions, the result returns #N/A, even though the requested
data exists in the master files.

I tried tracing using the formula audit toolbar, but it was of no
help. It went upto the last level of MATCH when it actually refers to
the cell (e.g. $T$51) of a master file. Although $T$51 in the master
file has a value, it (MATCH) returns #N/A!

If any of you have any idea, please let me know. You may post a reply
here or drop a PM.

Thanks a lot.