Loopupvalue

[AbelD]

I have 2 tables and looking for a formula that can look up a range thus search 4 and bring results in row 2

Entry	Account	User
1	xx	xxx
2	xx	xxx
3	xx	xxx
4	xx	xxx

Entry from	Entry to	Account
1	2
3	5	xxx

[BeaBF]

@AbelD Hi! Can you better explain the expected result?

BBF

[AbelD]

If the entry is 2 it must filter only row 1, as 2 is between 1 and 2