Lookup Question

**Brad P** · 06-04-2005, 04:08 PM

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges to pull over the group ID. I thought I could use Lookup & reference, index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

**olasa** · 06-04-2005, 05:33 PM

Are you looking for something like this (see encl. picture)?

Ola Sandström

RagDyeR · 06-04-2005, 06:05 PM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

**olasa** · 06-04-2005, 07:08 PM

Here is the file, as promised.

Hope it helps
Ola Sandström

RagDyeR · 09-05-2005, 10:05 PM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

RagDyeR · 09-05-2005, 11:05 PM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

RagDyeR · 09-06-2005, 12:05 AM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

RagDyeR · 09-06-2005, 01:05 AM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

RagDyeR · 09-06-2005, 02:05 AM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575

RagDyeR · 09-06-2005, 03:05 AM

Your question is not too full of factual information, as to actual data
configuration (date *ranges*???) and/or data list arrangement
(construction).

As a general example, say Sheet3 has a list if dates from B1 to B50, and
group ID's in A1 to A50.

On Sheet1, you enter a date in G10, and this formula in H10, which will
return the corresponding group ID from Sheet3:

If the matching date is *not* found on Sheet3, the #N/A error will be
returned to H10 instead:

=INDEX(Sheet3!A1:A28,MATCH(G10,Sheet3!B1:B28,0))

If you are *not* looking for exact matches to the date entered into G10, or
your list of dates is truly a *range* of dates, perhaps entered into 2
columns, post back with your exact datalist configuration for other
suggestions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Brad P" <[email protected]> wrote in
message news:[email protected]...

I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.

--
Brad P
------------------------------------------------------------------------
Brad P's Profile:
http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575