I have a cell M2 in sheetB.
I also have cell P2 in sheetA. P2 contains a value.
In SheetB cell M2 I want an equation that refers to the P2 value with the row function.
However, when I refer to =SheetA!P&ROW() then NAME error occures.
How do I write the equation with the ROW function?
If you specifically need with a row function you can do this-
But you could simply do this also -
=INDIRECT("SheetA!P"&ROW())
=SheetA!P2
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
I find the wording of your question a bit strange but these are possibilities for you. You don't say if the formula will be filled down the column or across columns in the same row or is just static in one cell.
See Msg#2
Formula:
=INDIRECT("SheetA!P"&ROW())
Formula:=SheetA!P2
Additions
Formula:=INDIRECT("SheetA!P"&ROWS(SheetA!$A$1:A2))
Formula:=INDIRECT("SheetA!P"&2)
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks