Linkage. Returns #N/A for certain entries
 

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.

Linkage. Returns #N/A for certain entries
 

There are many possibilities why your lookup is failing. Chceck

If the check range is absolute, that is it has $ sign
Check the case, small and upper case are different for lookup

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Matts" wrote:

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.

Linkage. Returns #N/A for certain entries
 

Many thanks for your reply Pranav.
I checked it. There's no $ sign atall.
I realise that the data (text format) is in UPPER CASE however. Didnt
realise this can be an issue. How do i get around this ?

"Pranav Vaidya" wrote:

There are many possibilities why your lookup is failing. Chceck

If the check range is absolute, that is it has $ sign
Check the case, small and upper case are different for lookup

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Matts" wrote:

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.

Linkage. Returns #N/A for certain entries
 

Hi Matts,

In any lookup() the values that are being complared must be in the same case.
You can convert either value to match with other. To do this you can use
UPPER() or LOWER() functions.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Matts" wrote:

Many thanks for your reply Pranav.
I checked it. There's no $ sign atall.
I realise that the data (text format) is in UPPER CASE however. Didnt
realise this can be an issue. How do i get around this ?

"Pranav Vaidya" wrote:

There are many possibilities why your lookup is failing. Chceck

If the check range is absolute, that is it has $ sign
Check the case, small and upper case are different for lookup

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Matts" wrote:

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.