Takes2ToTango
Board Regular
- Joined
- May 23, 2023
- Messages
- 63
- Office Version
- 365
- Platform
- Windows
I have been trying to create a forumla but I only seem to get errors once I hit enter. My goal is to use the lookup date and find the most recent one depending on which person is selected. For example, if Basil is selected the most recent date would be 06/09 and the result 45. However, if the person is changed to Steve, then the most recent date would change to 07/05 and the result 65. I have attempted arrays but nothing seems to deliver the right result.