REFERENCE CELL

  • Thread starter Thread starter JOHN
  • Start date Start date
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
 
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.
 
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.
 
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.
 
You must log in or register to reply here.

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

How can I remove the previous lock cells and keep the new ones. 2
Excel How to use the Excel IF function 4
IF formula 5
Help with multiplication part of formula 2
sum formula not working excel 03 3
sum and subtract hours 4
If cell value =0 then show "" 2
Deferring conditional formatting? 14

Back
Top