I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be automatically selected. The criteria for selection are: required power and required head (m).
I need to extract the right model from a table that compiles all pump models, their power, minimum head and maximum head.
The function should go as following: look up required power and head, choose the model that:
1- has power equal to or more required power;
2- and minimum head that is equal to or more the required head;
3- and maximum head that is equal to or less than required head.
I kept playing with VLOOKUP with IF/AND, Index/Match but failed to find the right forumla. Please help!
I’m using EXcel 2016 and Windows 10
By: HAZEM ELMAHI