Link problem

  • Thread starter Thread starter Leonard Lan
  • Start date Start date
L

Leonard Lan

I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.
 
I've found the answer from the listed topics, which said we can use indirect
or offset function to do this. But I am still puzzled about following
problem, please help me out, thanks in advance.

A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3
..
..
..

How can I use the indirect or offset function to make this easier? Thank you!
 
B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1
Click to expand...

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!B:B,ROWS(A$1:A1)*3-2)
A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3
Click to expand...

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!$3:$3,ROWS(A$1:A1)*3-2)
 
Your answer is great! It saved me thousands of minutes. Excel is a wonderful
tool. Thanks again for your great help.
 

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

If...rows and columns 3
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Copy non merged to merged cells again 1
1st Wed, 1st Sat, 1st Sun 5
sort and sum data range with some blank cells 1
result given from content of selected cells. 5
Use formula to populate cells 1
vlookup error 3

Back
Top