Wishmaster89
Board Regular
- Joined
- Jan 10, 2022
- Messages
- 77
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hi All
I have two sets of ID's and dates that i want to return the period code for. The dates are usually out by 1 day or 2(rarely) so I want to match the ID and month/year.
Can anyone help please?
This is what i currently have
I have two sets of ID's and dates that i want to return the period code for. The dates are usually out by 1 day or 2(rarely) so I want to match the ID and month/year.
Can anyone help please?
This is what i currently have
Excel Formula:
=INDEX(C1:C5,MATCH(A1&B1,F:F&G:G,0))
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ID | Date 1 | Period | ID | Date 2 | Return period where month/year matches | ||||
2 | 1 | 03/10/2022 | R1 | 1 | 04/10/2022 | #N/A | ||||
3 | 2 | 10/04/2022 | R2 | 2 | 11/04/2022 | |||||
4 | 3 | 29/03/022 | R3 | 3 | 30/03/2022 | |||||
5 | 4 | 01/08/2021 | R4 | 4 | 02/08/2022 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2 | H2 | =INDEX(C1:C5,MATCH(A1&B1,F:F&G:G,0)) |