when press enter the formula sign is missing

hello again...
I am having problem again with my worksheet
the problem is when I press enter the symbol 'Sheet1' is missing
for example :
I write the formula

=(IFERROR(VLOOKUP($A18,'Sheet2'!$A$3:$I$100,6,0),0)*1000)

when I press enter the formula become

=(IFERROR(VLOOKUP($A18,Sheet2!$A$3:$I$100,6,0),0)*1000)

what's wrong with my worksheet ? because I can take a data from other sheet

thanks before.

Don't understand the problem re 'Sheet1'

=(IFERROR(VLOOKUP($A18,Sheet2!$A$3:$I$100,6,0),0)*1000)

is OK. the single quotes (') are not required.

Perhaps post a file with the problem.

Hi,

If the sheet is only one word (no spaces) then you don't need ' ' around the name - so Excel removes the ' ' automatically.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.