Retrieve data in Excel using For Each Row and Collection

I can retrieve the data from an Excel table but need to refer to data from a previous row. Is this possible using the Add to Collection or is there a better way to do this?

Can you give some more information on what you want to do? Is the previous row a fixed row or dynamically changing?

I found it best to read all Excel data into a DataTable variable and work with that. That offers more native functionality in Studio.