Hi so I am trying to help one of the Superintendents here at my job fix a problem with one of his spreadsheets. He has a lookup formula on a daily attendance sheet that will bring up an employee's name and what type of job they hold if you type in the 3 digit number corresponding to that employee. Now mind you its not a Vlookup of index match formula, just simply lookup if that helps. That formula is linked to another workbook that is the source of that information. Overall, the formula is working for everyone when you type in their number on that attendance sheet, it will bring up their info. There is one person however that it is NOT working for. When we type in that number, it yields #N/A. When I open the source file that the attendance file is linked to, it shows his name, but not when it s closed. I'm not sure why it seems to display everyone else's name when closed but not his. Any thoughts as to how this can be fixed? Do you need more info?
Last edited: