Help needed on Search

[abashlal]

Hello All!

I need a help in automating my excel sheet attached with this thread..

I have to retrieve col from NEW sheet - Mark, IV, StardPrCu , StradPrPCu, StardPrNx, StradPrPNx for rows whose Time matches the value in cell Sheet1!D2 and the col 4 value is greater than matched Time's StardPrCu by 40% .. eg eg. i want to retrieve the rows which have StradPrPCu of col 4 greater by 40% than those having time of Sheet1!D2. These rows will be pulished in Sheet1! F1 onwards.

Any help with right formulas will be great!

[JohnTopley]

Please added some expected results to your file

[abashlal]

Re-attached. Pls refer tab Sheet1

[AliGW]

Your Office version is NOT Seattle - please update you4 profile.

Any help you get here will be for free - don’t use words like URGENT in your threads, please.