how to 'index (?)' a copy/populate function from one worksheet to another?

[cornbread_r_square]

Thx for looking. I want to populate data from one worksheet row, different columns into a separate worksheet columns, different row. On the latter worksheet (where I want my results of the copy/populate to appear in columns, different rows) I'd like to just copy from same row/3 columns down to the next row and to the next and the next, etc.

E.g., In columns O23, P23, Q23 from one worksheet i used the '=' sign to place the results from J46, L46, K46 from another into those 3 cells. Then I'd like to down arrow a row to O24, P24, Q24 on that 1st sheet and say, 'from my second sheet; insert/populate with the results of J46 (but over 5 columns), L46 (but over 5 columns), K46 (but over 5 columns)'. Then I want to go down to O25, P25, Q25 on that 1st sheet again and say, 'from my second sheet; insert/populate O25, P25, Q25 on that 1st sheet with the results of J46 (but over 5 MORE columns), L46 (but over 5 MORE columns), K46 (but over 5 MORE columns).'

Thx alot

Hi I just tried to add a couple screen shot attachements of the two worksheets I'm dealing with. thx

[Pete_UK]

It would help if you attached a sample Excel workbook, in which you might be able to explain more clearly what you want to achieve.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[FDibbins]

If you are just returning 1 particular entry, depending of a row and column heading, you could probably use INDEX/MATCH/MATCH for that.

INDEX returns a value at the intersect (meeting) of a row and a column.
INDEX() syntax is =INDEX(range,row-num,column-num)
so something like =INDEX(A1:J10,3,5)
will return the contents of E3 (row 3, column 5)
Didnt even use MATCH, did we?

Now, to find the "3" or the "5", we would use the MATCH function...
MATCH syntax is...=match(criteria-to-find,column-to-search-in,0) 0 returns exact match
=MATCH("cc",A1"A10,0)
If "cc" is in A3, this will return 3
(to find the column number, we use the same thing, just change the range=MATCH(criteria-to-find,row-to-search-in,0)
'=MATCH("zz",A1:J1,0)
If "zz" is in E1, then this will return 5

Put them all together and you have...
=INDEX(A1:J10,MATCH("cc",A1:A10,0),MATCH("zz",A1:J10))