Bad Lookup Formula- Wrong File

PROBLEM

Changes in Master Index don't seem to affect the accounting Ledger or Log. Completely weird stuff showing up in 'jobsite' or 'who to' columns. Lookup formulas are not working properly. Shows #NAME! in 'jobsite' or 'who to' when using MacNail Construction Accounting Software

DIAGNOSIS

Check the formula in the 'jobsite' or 'who to' column. It should read =....LOOKUP(xx,'master index'!suppliers... or something similar. If it reads =....LOOKUP(xx,'another file'!suppliers.... or =....LOOKUP(xx,'disk:macnail: accounts: current accounts:master index'!suppliers...., it has problems.

If blank or a value (no formula), just needs new lookup formulas. Same solution.

SOLUTION

Select all the rows with the bad reference. Choose *Lookup formulas to remove lookups, then choose it again to put them back in correctly.

EXPLANATION: If they use 'save as' to save the Master Index under another name, all files open at the time will have their lookup formulas adjusted to refer to the new file. That's a no-no, we always expect the master index to be named 'master index' and have problems if it's somewhere else or something else!

DOS name: master.ndx

COMMENTS

Entered 10/9/92 by Dennis.