| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two column ranges with a date
Hi everyone,
In short, I have Column A with a range of contract numbers from A2:A7113. Column B has a range from B2:B354. Column C has a specific date for the contract number in Column B. I need a formula that take a contract number from Column B and searches for it's match in Column A. If there is a match, it needs to enter the date coinciding with that contract from Column C. If there is no match, then it should leave it blank. Although I've tried using the IF statement, I haven't been able to find an effective formula that includes ranges correctly. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCHING DATE TO A WEEKDAY | Excel Worksheet Functions | |||
| Sum Rows with a matching date | Excel Discussion (Misc queries) | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| Matching a Date question | New Users to Excel | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
Threaded Mode
