lundi 26 janvier 2015

If and then, search

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. 1 - Brown, Sam

  2. 2 - Simmons, Donald

  3. 3 - Smith, John

  4. 4 - Doe, John

  5. 5 - Lee, Joe

  6. 6 - Smith, Joey

  7. 7 - Smith, John

  8. 8 - Smith, John

  9. 9 - Smith, John


Aucun commentaire:

Enregistrer un commentaire