Calgaryexcel
New member
- Joined
- Jul 22, 2020
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
I'm trying to build a replace formula, but want the data to be pulled from a list that has two columns with 107 rows. The first column would have staff names, and the second would have staff community of residence. Essentially if a staff name is entered in a cell, I want the text to be replaced with the community associated with the staff.