Linkage. Returns #N/A for certain entries

[Matts]

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.

 

[Pranav Vaidya]

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,

 

[Matts]

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]

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,