Hopefully an easy solution:
Look for value of C2 in Column range N3:N300. If found, then put value of P* into D2.
Example:
C2 = "Cat"
Search N3:N300 for "Cat"
Finds N176 = "Cat"
Then makes D2 = value of P176, in this case, "feline"
Is there Excel formula to do this?
Aucun commentaire:
Enregistrer un commentaire