| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find row in interval?
Thanks a lot!
Regards, S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Function | Excel Discussion (Misc queries) | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Linear Mode
