Linkage. Returns #N/A for certain entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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,
 
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 ?
 
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,
 
Back
Top