How to find row in interval?
 

I have a sheet with account group intervals like this:

Name | From | To
Group 1 | 3000 | 3599
Group 2 | 3600 | 3999

In my regular sheet I need to find out which account group above a
given account belongs to. If I for example have account 3010 in cell A1
I need to look up and show the account group name "Group 1" in cell A2
since 3010 is in the interval 3000 | 3599.

How can I do that?

Regards,

S

How to find row in interval?
 

=INDEX(GroupSheet!A2:A1000;MATCH(A1;GroupSheet!B2: B1000;1))

HTH
--
AP

a écrit dans le message de news:
...
I have a sheet with account group intervals like this:

Name | From | To
Group 1 | 3000 | 3599
Group 2 | 3600 | 3999

In my regular sheet I need to find out which account group above a
given account belongs to. If I for example have account 3010 in cell A1
I need to look up and show the account group name "Group 1" in cell A2
since 3010 is in the interval 3000 | 3599.

How can I do that?

Regards,

S

How to find row in interval?
 

Thanks a lot!

Regards,

S