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

126 thoughts on “VLOOKUP & IF OR MATCH/INDEX

  1. Sewa Bus Pariwisata Jakarta

    Hello. This specific awesome article couldn’t end up being written much better! Reading through this post reminds myself of my previous space mate. He always retained chatting about this. We will forward this web site to him. Fairly particular he will have the good read. Thank an individual for sharing.

  2. buy peptides online

    fantastic put up, very informative. I ponder why the other experts of this sector don’t notice this. You should proceed your writing. I’m sure, you have a huge readers’ base already!

  3. Buy phentermine HCL online

    Please let me know if you’re looking for a article writer for your blog. You have some really good posts and I think I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some content for your blog in exchange for a link back to mine. Please shoot me an e-mail if interested. Thank you!

  4. Buy Melanotan 2 online

    Good day! This is my first visit to your blog! We are a team of volunteers and starting a new project in a community in the same niche. Your blog provided us valuable information to work on. You have done a extraordinary job!

  5. produksicetak

    I was curious should you ever considered changing the structure of the site? Its quite well written; I like what you’ve got in order to say. But maybe an individual could a little extra when it comes to content so folks could connect with that better. You have an terrible lot of text intended for only having one or perhaps 2 pictures. You may can space it out much better?

  6. Sibutril in deutschalnd Kaufen

    Does your website have a contact page? I’m having trouble locating it but, I’d like to send you an email. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it grow over time.

  7. Bestellen

    I really enjoy looking through on this website, it has good content. “The living is a species of the dead and not a very attractive one.” by Friedrich Wilhelm Nietzsche.

  8. Phentermine online kaufen

    I discovered your blog site on google and check a few of your early posts. Continue to keep up the very good operate. I just additional up your RSS feed to my MSN News Reader. Seeking forward to reading more from you later on!…

Comments are closed.