| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
index / match
I have the following data
date MEETING 1 MEETING 2 01-09-2008 1 10 01-10-2008 2 20 01-11-2008 3 30 I would like a formula that gives me the value that meets both criteria: meeting 1 on 01-09-2008. date MEETING 1 MEETING 2 01-09-2008 ?? ?? 01-11-2008 ?? ?? Thank you, Deborah |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
index / match
What do you expect to see in your second table? Are you wanting to add
the values from the first table which match the second table criteria? Pete On Feb 9, 3:05*pm, Deborah wrote: I have the following data date * * * * * * * * * MEETING 1 * *MEETING 2 01-09-2008 * * *1 * * * 10 01-10-2008 * * *2 * * * 20 01-11-2008 * * *3 * * * 30 I would like a formula that gives me the value that meets both criteria: meeting 1 on 01-09-2008. date * * * * * MEETING 1 * MEETING 2 01-09-2008 * * *?? * * * * * * ?? 01-11-2008 * * *?? * * * * * * ?? Thank you, Deborah |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
index / match
Hi Deborah
Enter in B2 of Sheet2 =INDEX(Sheet1!$A$:$C,MATCH(Sheet1!$A:$A,$A2,COLUMN (B1),0) Copy Across and down as required -- Regards Roger Govier "Deborah" wrote in message ... I have the following data date MEETING 1 MEETING 2 01-09-2008 1 10 01-10-2008 2 20 01-11-2008 3 30 I would like a formula that gives me the value that meets both criteria: meeting 1 on 01-09-2008. date MEETING 1 MEETING 2 01-09-2008 ?? ?? 01-11-2008 ?? ?? Thank you, Deborah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Hybrid Mode
