• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Two range lookup with two diff if between variables

M

MRF

New Member
I have a simple chart with two diff variables yielding a result...if n is between this and this it gives this number on the chart but also if n2 is between this and this it give this number. I am trying to chart. The vlookup only takes into account the column variable...
 

Attachments

Hi Melissa,

Welcome to the forum.

If you change a lil bit in your data, it will be lot easier for you..
check the attached.. Few basic changes has been done..
Let us know.. if this is working for you..

=INDEX(C10:H15,MATCH(D2,B10:B15,1),MATCH(D3,C9:H9,-1))
 

Attachments

You must log in or register to reply here.
Back
Top