Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Question
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 |
#2
|
|||
|
|||
Are you looking for something like this (see encl. picture)? Ola Sandström +-------------------------------------------------------------------+ |Filename: Clipboard01.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3457 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=376575 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
Here is the file, as promised. Hope it helps Ola Sandström +-------------------------------------------------------------------+ |Filename: Book4.zip | |Download: http://www.excelforum.com/attachment.php?postid=3459 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=376575 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Type Question | Excel Worksheet Functions | |||
Formula Question... LookUP | Excel Discussion (Misc queries) | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Lookup Question | Excel Worksheet Functions | |||
Lookup and Sort Question | Excel Discussion (Misc queries) |