Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Access linkage | Excel Discussion (Misc queries) | |||
Time Sheet list linkage | Excel Worksheet Functions | |||
worksheet linkage | Excel Discussion (Misc queries) | |||
how to change cell linkage | Excel Discussion (Misc queries) | |||
Linkage data between two spreadsheet | Excel Worksheet Functions |