J
JOHN
I have this ='Travel Task 2'!H20 and I am getting #Ref - despite the fact
that H20 is the correct cell. Please help. Thanks
that H20 is the correct cell. Please help. Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Are you sure that in that same workbook you have a sheet named Travel Task
2?
If you are still struggling, insert the formula again by typing the = sign
then going to your Travel Task 2 sheet and clicking in cell H20, then accept
the formula.
2?
If you are still struggling, insert the formula again by typing the = sign
then going to your Travel Task 2 sheet and clicking in cell H20, then accept
the formula.
D
Dave Peterson
I'd bet you made a typo. Maybe an extra space (leading/trailing or embedded)??
Try selecting H20 on that "sending" sheet
Edit|copy
go to the "receiving" cell
edit|past special|paste link
And check out the formula that excel builds.
You could also accomplish the same thing by typing the equal sign, then
navigating to that cell, selecting it and hitting enter.
Try selecting H20 on that "sending" sheet
Edit|copy
go to the "receiving" cell
edit|past special|paste link
And check out the formula that excel builds.
You could also accomplish the same thing by typing the equal sign, then
navigating to that cell, selecting it and hitting enter.
E
Earl Kiosterud
John,
How about the sheet name? If it's even slightly misspelled, you'll get this error. Try
rebuilding the formula, either as a formula (type =, go click H20 in the other sheet, and
press Enter), or as a copy from H20 and a paste-link into your original cell.
How about the sheet name? If it's even slightly misspelled, you'll get this error. Try
rebuilding the formula, either as a formula (type =, go click H20 in the other sheet, and
press Enter), or as a copy from H20 and a paste-link into your original cell.