Vlookups IF statements etc

[hetal247]

Hi,

I have 2 tables:

What I am trying to do is an vlookup and if statement to return the result column in table 1. so if my lookup value is 132, the for client 3, I want it to look at table 2 and find the result where value 1 and value 2 is between 3.2 therefore the result would be 4.

Is there an easier way to do this? I am struggling and been searching for a solution on the internet without any luck. Hoping that somebody can help me with this.

Much Appreciated

Hetal

 

[jasonb75]

Assuming no duplicate / overlapping entries in table2

=SUMIFS(Result,Index,132,Value1,"<="&Rating,Value2,">="&Rating)

I've used the column headings from your screen captures as descriptions in the formulas to show what each part should refer to.

 

[hetal247]

Assuming no duplicate / overlapping entries in table2

=SUMIFS(Result,Index,132,Value1,"<="&Rating,Value2,">="&Rating)

I've used the column headings from your screen captures as descriptions in the formulas to show what each part should refer to.

Hi Jason,

Thank you for coming back to me quickly. I have tried this and unfortunately still does not work. It is possible to have duplicate values 1 and value 2 in the table but when looking at the index, there should only be a single entry.

Hope that makes sense

kind regards

Hetal

 

[jasonb75]

There can be duplicates in the value cells as long as each row is unique, from the example in your post there are no duplicate rows.

Once you wet the formula to match your sheet ranges it will work fine.

 

[hetal247]

There can be duplicates in the value cells as long as each row is unique, from the example in your post there are no duplicate rows.

Once you wet the formula to match your sheet ranges it will work fine.

That's brilliant. It works now. Thank you for you help

kind regards

Hetal