Display a single value from a row/range

Hello there.

This is my first post here, and after reading through the rules I will try to be accurate and to the point. I am a learner at excel formulae and I am pretty much teaching myself as I go.

What I have been trying to do is find a formulae that will display to a single cell, a value that is determed from a number of certain conditions being met.

Sample data.
Hardware/Timing, 180, 360, 540, 720
Desktop, Good, Ok, Bad, Very Bad
Laptop, Good, Ok, Bad, Very Bad

I already have conditions in place that will hide text values if the condition is not met, so for example if a Desktop's bootup time is greater than 360, and less than or equal to 540, then all other values on that row will remain blank except for the Bad text string.

What I've been trying to achieve is if the Hardware is equal Laptop or Desktop, search that row for the only text visible and display that text to a single cell. This very well may not be possible but I had to ask the question as I can't think of the logic to achieve this and display the result to a single cell.

Many thanks

Les Butler

Thanks you Rateesh

That forulae has indeed done the job and is working superbly.

Many thanks again.

Les Butler