If Then Formula

I am trying to create an If Then formula to create a table. What I do is dump data from a website into Excel (see attachment) into columns A and B. I have set up a table so that if certain data is in column B then a name will appear in Column C.

So what I would like to do is create an If Then formula saying, If a certain name in Column C appears then the transaction amount would go in one cell and the value date would go in another.

I would like to have a worksheet for each name in that is in column C. I have 35 possibilities that could show up. If that name shows up in column C then I would like that transaction amount in one cell and the value date in another cell.

So if a certain name shows up in column C then 6 cells above it in column A would be the value date.

And then in another cell, if a certain name shows up in column C then 3 cells above it in column A would be the transaction amount.

Is a formula like this possible?