Copy formula that spans several rows of data

Hi guys,

I have been manually entering a nested IF statement row after row for some time now and decided to see if there is a better way to accomplish this. Attached is a screenshot of a portion of my raw data.

Untitled.png

What I want to do is extract the data collected for each sample to its own worksheet within this excel file. So my loop consists of "IF this sample is sample 1 then copy this cell, IF this sample is sample 2 then copy this cell, and so on." Attached is an image of what I want as an end result.

Individual Sample.png

The issue I am having is that my IF formula has to check 6 different rows for each time measurement. For example, at t=0.25 hrs my formula checks values in rows 9 through 14 and for t=0.50 hrs the formula checks values in rows 15 through 20. Whenever I try to copy my nested loop formula from one row to the next the values due not iterate the way I need them to. Is there a way to do this, or am I stuck typing away?

Thanks!

Welcome to the forum.

Can you post a real sample workbook so that members could offer solutions.
Thank you for joining.

Try this.

Please Login or Register  to view this content.

And copy to right and down the cells.

in column K .... sheet name -> "All Sample"
you can change this formula

=IF(C3=1,($O$4/$P$9)*J3, IF(C3=2,($O$4/$P$10)*J3, IF(C3=3,($O$4/$P$11)*J3, IF(C3=4,($O$4/$P$12)*J3, IF(C3=5,($O$4/$P$13)*J3, IF(C3=6,($O$4/$P$14)*J3))))))

to this one.

Formula:

Please Login or Register  to view this content.

Yes you are right. The formula is incorrect. In fact it is not even correct for the value 1 in cell E1.
The formula is returning the wrong value in both the cases. I am sorry that I didn't check it.
But don't worry, this forum is full of experts and someone would definitely come up with a solution to your query.
Hope you will get the desired formula.