VLOOKUP & IF OR MATCH/INDEX

Hello,

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

Leave a Reply

Your email address will not be published. Required fields are marked *