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
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