Get value in Table A based on another Table B

[#1]

Hello Friend,

I have two tables as follow.

Table A:

POINT FROM	POINT TO	VALUE
0	25	10
26	50	20
51	75	30
76	100	40

Table B:

CALCULATED POINT	EXPECTED RESULT
55	? (30)
20	? (10)
74	? (74)

Here Table A is master data.

I want to get expected result value in Table B based on Table A (Master Table) Point from and To.

for Ex.

Table B: Calculated Point = 55, Expected result = 30

Table B: Calculated Point = 20, Expected result = 10

Table B: Calculated Point = 74, Expected result = 30

Please let me know any solution.

Thanks

[#2]

Hi

as far as i remember  "interval match" function should solve the problem.

if not try "class"

best regards

chris

[prodanov]

This is a script for IntervalMatch

[Anonymous · Accepted solution]

Hi Dipak

Create a Chart and use the following expression in that

=if((CALCULATEDPOINT>POINTFROM And CALCULATEDPOINT<POINTTO),VALUE)

please find the below attachment 

Regards

Harsha