Excel Conditional Functions (Engineering Model)

Hi,
I'm not a regular user of Excel so I may just be missing something or not aware that this tool exists but this is what I'm trying to achieve...

My task is to solve a lift design problem. I have 5 different winches to use depending on the Required Output of a number of different scenarios. I have 1 column where the required output is calculated and I want to display which winch will work in the column next to this depending on the output number. I have attached the spreadsheet I'm working on so you can see (it's on the Technical Analysis tab). I know about the =IF function but how do I apply a number of conditions to that whole column?

E.G. If the required output is 104kW I want the cell next to it to display W150 (the winch that will work the best for the situation).

After I get this working I will then need to do another condition on the Winches to display the cost of that winch in the next column across.

Is something like the possible?

Thanks,
Jen.

Model.xlsx

That's awesome! Worked perfectly!
Thanks vlady!