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