Hi,
I have a 'master' spread sheet that is linked up to various independant
sheets managed by different branches.

My problem : Some values returns as '#N/A' . On closer Observation it tends
to pick up A particular type of entry. In my case the text ' INVESTMENT LEAD'
doesn't get fed into the master atall. It appears as '#N/A' against all such
entries.

How Can I resolve this ?

Thnx
Matt.