| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
