Automatically find a paste data from range

[Poppin1337]

I need an equation that will scan a data range and automatically paste the relevant data in a table. In the attached picture, i need the 2 - 60% values from T/Ts = 1 to be pasted in the table in the top right. I also need the data for T/Ts values for 2,3,4,5. And if you have time, I am struggling with an interpolation equation that will allow me to get the T/Ts values for 0.25 and 0.5 as they are not always exact. Thank you!

[quekbc]

Could post a sample workbook (with sensitive data removed)? Makes writing an appropriate solution easier.

[Poppin1337]

Spreadsheet for reference. Thanks

[cbatrody]

Hi,

Try the following formula in X6:

=INDEX($L$3:$U$504,MATCH($W6,$L$3:$L$504,0),COLUMN(C$2))

drag this formula to the right.

Also, I see that there are no EXACT matches for 0.25 and 0.5 in T/Ts column. How would you go about them?

[Potholes]

Good evening

I have used a vlookup formula in your file, If will help.

Pete

[Poppin1337]

Thanks, cbatrody. Your formula worked for me. As for the 0.25 and 0.5 values, I will have to perform interpolation separetly in order to get those values.

Thank you Pete. Your formula also worked. Its going to save me alot of time!