Re: How to find row in interval?

Giganews Newsgroups
Subject: Re: How to find row in interval?
Posted by:  Ardus Petus (ardus.pet…@laposte.net)
Date: Tue, 23 May 2006

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

HTH
--
AP

<stae…@gmail.com> a écrit dans le message de news:
1148383344.578380.2704…@j73g2000cwa.googlegroups.com...
>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

Replies

In response to

How to find row in interval? posted by stae…@gmail.com on 23 May 2006