taraajordan
New Member
- Joined
- Oct 16, 2019
- Messages
- 2
Hello,
I have a list of dates and I need an excel formula that will match the date with another set of dates and if they match, then return a different value to me. For example, I have the list of dates below and I need to compare that list with another list of dates. If they match, I need the pay period number that corresponds with each of those dates to be returned. I'm hoping someone can help!
I have this list:
<colgroup><col></colgroup><tbody>
</tbody>
I have a list of dates and I need an excel formula that will match the date with another set of dates and if they match, then return a different value to me. For example, I have the list of dates below and I need to compare that list with another list of dates. If they match, I need the pay period number that corresponds with each of those dates to be returned. I'm hoping someone can help!
I have this list:
11/10/2019 | ||||
11/10/2019 | ||||
11/24/2019 | ||||
11/24/2019 | ||||
3/1/2020 | ||||
3/1/2020 | ||||
4/26/2020 | ||||
4/26/2020 | ||||
5/24/2020 | ||||
8/16/2020 | ||||
8/16/2020 <colgroup><col><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>