Select field between available ranges

[#1]

I have 3 account numbers:

1000000

1500000

2000000

I have 5 ranges with names

Range name A with accounts 10000000 to 1399999

B, 1400000, 1599999

C, 1600000, 2500000

QV must return the right range name.

Thank you.

[vidyut · Accepted solution]

Try using IntervalMatch .

[#3]

Hi,

see the attached example. The keyword is INTERVALMATCH.

Good luck!

Rainer

[#4]

Very helpful, thank you.