Multiple formula to transpose data

[Pubhub]

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

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...able-data.html

Your original thread will be moved to this forum section.