BorisPlankton Posted June 13, 2008 Report Share Posted June 13, 2008 Hello,Using Excel 2007 but TBH I have experienced this problem across range of Excel versions.Constructed Lookup fine and it returns result I expect. Later when the file is reopened the formula seems to fall over and certainly does not return the same result.If you then simple retype the formua exactly as was the result is as expected and as it was before when all was well. Oddly other cells in folder containing lookups work and are reading from same source workbook as those 'failing' and giving good results.File save of Excel workbook large (50-175Mb). I cannot recall this problem occuring with any other function but I guess this could be because RAM insufficient? Or Excel itself simply cannot deal.At a bit of a loss really. Kind RegardsPaul Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.