rosetc16
New member
- Joined
- Apr 22, 2017
- Messages
- 43
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
All,
Really appreciate your help. I've attached an example (below) for what I'm looking for. I have unique IDs for each person, but there are multiple rows for certain people who obviously will have the same ID. How do I get the lookup values in the VLOOKUP to match up with the 1st, 2nd, 3rd, etc. occurrence. I think I might have to use an index/match function, but I don't really understand how they work. Thanks!
View attachment Example.xlsx
Really appreciate your help. I've attached an example (below) for what I'm looking for. I have unique IDs for each person, but there are multiple rows for certain people who obviously will have the same ID. How do I get the lookup values in the VLOOKUP to match up with the 1st, 2nd, 3rd, etc. occurrence. I think I might have to use an index/match function, but I don't really understand how they work. Thanks!
View attachment Example.xlsx