Forum Discussion

AbelD's avatar
AbelD
Regular Visitor
3 years ago

Loopupvalue

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

EntryAccountUser
1xxxxx
2xxxxx
3xxxxx
4xxxxx

 

Entry fromEntry toAccount
12

 

35

xxx

2 Replies

    • AbelD's avatar
      AbelD
      Regular Visitor

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