saltoftheearth
New Member
- Joined
- Feb 29, 2020
- Messages
- 6
- Office Version
- 365
- 2019
- Platform
- MacOS
Hello!
Similar to the topic of this thread. I have two columns.
Please let me know what else I can provide. Sorry if this question has been asked too many times to count already
Similar to the topic of this thread. I have two columns.
- Column A has a series of IDs and column B has a series of dates
- Column A can have repeated values
- There are two tabs
- Data tab has the IDs and dates
- lookup tab has the IDs
- I could use some help in creating a formula that looks up the IDs in column A on lookup tab and returns the max date from data tab associated to the ID in column A on lookup sheet
- I have attached two images with the tabs (not sure how
Please let me know what else I can provide. Sorry if this question has been asked too many times to count already
| Sample data seet.xlsx | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | IDs | Dates | ||
| 2 | 1 | 2/20/24 | ||
| 3 | 1 | 2/20/24 | ||
| 4 | 1 | 3/20/25 | ||
| 5 | 2 | 1/11/22 | ||
| 6 | 2 | 2/10/24 | ||
| 7 | 3 | 5/15/21 | ||
| 8 | 4 | 5/15/22 | ||
| 9 | 4 | 5/15/23 | ||
| 10 | 2 | 1/10/24 | ||
| 11 | 2 | 2/10/24 | ||
| 12 | 1 | 3/26/26 | ||
Data Set | ||||
| Sample data seet.xlsx | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | IDs | Max Date | ||
| 2 | 1 | |||
| 3 | 1 | |||
| 4 | 2 | |||
| 5 | 2 | |||
| 6 | 3 | |||
| 7 | 4 | |||
| 8 | 4 | |||
| 9 | 2 | |||
| 10 | 2 | |||
| 11 | 1 | |||
| 12 | 1 | |||
| 13 | 1 | |||
| 14 | 2 | |||
| 15 | 2 | |||
| 16 | 3 | |||
| 17 | 4 | |||
| 18 | 4 | |||
| 19 | 2 | |||
| 20 | 2 | |||
| 21 | 1 | |||
| 22 | 1 | |||
| 23 | 1 | |||
| 24 | 2 | |||
| 25 | 2 | |||
| 26 | 3 | |||
| 27 | 4 | |||
| 28 | 4 | |||
| 29 | 2 | |||
| 30 | 2 | |||
| 31 | 1 | |||
Lookup datees | ||||
