#VALUE error which disappears when I use F2, ENTER

T

TRE

I have a number of simple formulae of the form:
=HLOOKUP(EOMONTH(DATEVALUE("31/12/2011"),COLUMN(A1)),$C$2:$ND$49,ROW(A37),FALSE)

Regularly, when I open the workbook, this block of formulae display the #VALUE error. There appears to be nothing wrong with the formulae, however. IfI select any such cell and press F2, then hit Enter again (making NO changes), the formula returns the right result again.

I then have to do this in each row and copy the formulae across again and it works fine.

Any suggestions on what causes this? Something to do with the two date functions perhaps (these seem to cause trouble in Excel generally)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value# error 0
unknown #value error 0
Paste error 0
Spreadsheet produces error values 3
data disappears when I press F2 to edit 0
#VALUE! error when I try to insert a row 0
VBA Type mismatch error 2
use error handling to assign value 5

Top