Please help :) If cells A1:A9 contain "3", then I would like the name to populate. I'm okay with the full cell text to populate as well (i.e. 3 - Smith, John).
Below is a list providing cells A1:A9.
- 1 - Brown, Sam
- 2 - Simmons, Donald
- 3 - Smith, John
- 4 - Doe, John
- 5 - Lee, Joe
- 6 - Smith, Joey
- 7 - Smith, John
- 8 - Smith, John
- 9 - Smith, John
Aucun commentaire:
Enregistrer un commentaire