Converting information to more presentable data

Good morning,

I am having difficulty completing the attached automatically. I have tried multiple formula's but unable to get the desired results. Vlookups, hlookups, match, and a combination of each.

The Data tab contains a selection of timings completed for a particular operation (Timed Values 1-93). This data has then been used to get the average, standard deviation, upper and lower control lines. We use this data to convert to graphs to show the times for the action in Column D. The information in column F to J are fixed values. I would like to use formulas to create the information on the desired results tab, but using the drop down in A2 to change the values in the table.

Any assistance would be greatly appreciated.

Pete

Morning ALi,
This has now bin updated, thank you for the response.
Pete

Hi Ali,

I am wondering if there is a way to delete this thread, I realised I didn't post it in the formula section. I have just posted in there and don't want the thread on multiple tines.

Pete

In your "Formula" worksheet paste below formula in Cell D4 and drag down:

=OFFSET(Table1[[#Headers],[Col D]],MATCH($A$2,Table1[Col D],0),ROW(C13))

and in Cell E4 use below formula and drag it below and right:

=VLOOKUP($A$2,Table1[[#All],[Col D]:[93]],MATCH(E$3,Table1[[#Headers],[Col D]:[93]],0),0)

See attachment for reference

Hope it helped you?

Thank you Naren_Kumar, that has worked exactly as required.
Thank you for your assistance and apologies Ali on the issue caused.

Pete

Thank you Olly, That is much appreciated.
Ive never used a Power Query before and didn't think i could complete it through a Pivot table.

Thank you Both.