LinkBack URL
About LinkBacks
I would like a formula that produces the cell C2. I would then drag that formula down to the next cell and that would produce C7, after that C12, then C17 and so on....
Very much appreciate any help
Thanks,
Zack
I would like a formula that produces the cell C2. I would then drag that formula down to the next cell and that would produce C7, after that C12, then C17 and so on....
Very much appreciate any help
Thanks,
Zack
This depends what row the formula is in but works in row 1
="C"&(ROW()-1)*5+2
Adjust +2 accordingly depending on what row you are pasting this to.
Use the INDIRECT formula on the result of this to get what you want
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I think there was some miscommunication on my part...Basically I want cell A1 on sheet 2 to identify the value of whatever is in cell A1 on sheet 1. Then, cell A2 on sheet 2 would bring up the value of cell A6 on sheet 1, and so on...
I attached an example
Thanks
Try this in Sheet2 A1:
=OFFSET(Sheet1!$A$1,(ROW()-1)*5,0)
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks