• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

OFFS€ET use

Status
Not open for further replies.

arifanmol

Member
can we go to upward cell using offset in excel
like
a 10
b 20
c 30
i want to go to cell with '10' from cell with 'c'
 
As OFFSET is a volatile function you should avoid it to be on the safe side. What are you trying to do ?
 
What do you mean by "go to" exactly? OFFSET can refer to cells in any direction but it doesn't go anywhere.
 
This is your file screenshot.

82630

Your Question: "Can Offset formula help me?"

Ans: "How to go? Formula cannot help."

The answer is given above,

so

this thread is closed.
 
Last edited:
Status
Not open for further replies.
Back
Top