Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieving an Item from a List that Meets Multiple Criteria
I would like to get Date1 (and Date2) from Worksheet Misc and place it in Worksheet Client. I have been using the following function: =INDEX(Misc!$A:$C,MATCH(C259,Misc!$A:$A,0),2). This will work when there is one instance of the company or the dates are the same for multiple instances. It will retrieve the first date when there is more than one occurrence of a company, but I need each one, probably matched on company and last/first name Worksheet: Client Date1----Date2--- Company------------------Title------First-----Last Xx/xx/xx- xx/xx/xx-Associated Data Services---Mr.-------Jerry-----Stofel Xx/xx/xx- xx/xx/xx-Associated Grocers---------Mr.-------Ron------Burke Xx/xx/xx- xx/xx/xx-Associated Grocers---------Ms.-------Jackie---Plott Worksheet: Misc Date1----Date2--- Company------------------Title------First-----Last 12/01/05--N------Associated Data Services---Mr.-------Jerry-----Stofel -N--------N------Associated Grocers---------Mr.-------Ron------Burke 01/13/06--N------Associated Grocers---------Ms.-------Jackie---Plott I have gotten replies about changing the function to an array, but I have not understood the replies or research on the subject. If someone could "dummy it down" for me a bit, I would appreciate it. -- hgopp99 ------------------------------------------------------------------------ hgopp99's Profile: http://www.excelforum.com/member.php...o&userid=30699 View this thread: http://www.excelforum.com/showthread...hreadid=503622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
Multiple criteria LOOKUP | Excel Worksheet Functions | |||
Extract each item in the list | Excel Worksheet Functions | |||
Extract each item in the list | Excel Worksheet Functions | |||
Single list from multiple sheets | Excel Worksheet Functions |