# Return cell value 30 cells after reference cell

1. ## Return cell value 30 cells after reference cell

Hi I want to find the cells 30 past the reference cell and the corresponding value:

ie =Sheet1!D312 to =Sheet1!D342 (=Sheet1!D(312+30))

or

=Sheet1!D312 to =Sheet1!E312

is there a way to automate this without having to manually edit each formula?

2. ## Re: Return cell value 30 cells after reference cell

May be this.....

``Please Login or Register  to view this content.``
In this case D312 is the referenced cell and the value is returned from the cell D342.
Is this what you want?

3. ## Re: Return cell value 30 cells after reference cell

That is PERFECT!! Thank you so much!!!

5. ## Re: Return cell value 30 cells after reference cell

Just one more question, how would I refer to the formula in the cell? ie

lets say my cell shows :

19/03/1999 the formula being =Sheet1!D312

How would I use =offset in this situation? If I do =offset(F4,-1,0) then it will use the current sheet but I want it to refer to the reference of F4? Does that make sense?

So without having to =offset(Sheet1!D312,-1,0) each time manually?

6. ## Re: Return cell value 30 cells after reference cell

I am not clear, what do you want to do exactly?
The formula =offset(F4,-1,0) will return the value of cell F3. In the formula F4 is the referenced cell.

7. ## Re: Return cell value 30 cells after reference cell

Capture.JPG

I want to automate that.

8. ## Re: Return cell value 30 cells after reference cell

Better if you upload a workbook rather than an image. Highlight the cell which have formulas and the expected values in them with an explanation about how do you expect those values in them.
Because in the image I don't think that your referenced cell are in a particular or set order.

9. ## Re: Return cell value 30 cells after reference cell

TLS data.xlsx
I want to be able to automate the formula so that I don't have to manually type in =offset(Sheet1!D720,-1,0)

I would like to be able to drag the formula down to complete for the rest of the data set as well.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1