Hello everyone
In sample file I have 2 range (green and yellow)
In column A I have Power (kW) value(70 & 100)
In the blue range I want to have a formula that displays the corresponding range by entering the amount of power in cell F2
The correct answer for the value 70 is shown in the orange range.
Thank you for your help
Bookmarks