Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match 2 columns + corresponding date?
I've managed to match two columns (B + K) and return the value in a third
column (D) using the formula below. =INDEX(B2:L1204,MATCH(K2,B2:B1204,0),3) Here's where I'm stuck... there are multiple matches to some items in Columns B and K. I only want to return the value of the B/K match that also has a matching date. Columns C and L contain the dates. I'm driving myself nuts trying to figure this out! Thanks to anyone who can provide a suggestion! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match 2 columns + corresponding date?
This is one of my favorite sites:
http://www.contextures.com/xlFunctions03.html Make sure you look at Example 4 As an aside, a Pivot Table may give you what you want, and it would probably be a whole lot easier. Regards, Ryan--- -- RyGuy "cropgrl23" wrote: I've managed to match two columns (B + K) and return the value in a third column (D) using the formula below. =INDEX(B2:L1204,MATCH(K2,B2:B1204,0),3) Here's where I'm stuck... there are multiple matches to some items in Columns B and K. I only want to return the value of the B/K match that also has a matching date. Columns C and L contain the dates. I'm driving myself nuts trying to figure this out! Thanks to anyone who can provide a suggestion! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Date/Time to Date list | Excel Worksheet Functions | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
If columns match | Excel Worksheet Functions | |||
How do i Match all COLUMNS? | Excel Worksheet Functions |