mardi 8 décembre 2015

If this value is found in a range, then use the value next to the range result

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