OKay I am using the same formula on my entire worksheet IF ='Top Level'!E001 for some reason most of the cells are blank and will dictate what I want form a previous page but then I have a few that wont and show the formula in the cell instead. I have tried deleting the formula saving the worksheet and tring to type it in manually and still no help, what can I do?
Bookmarks