Comparing, retrieving, and inputing data

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I would like to know how to get excel to compare a partial list of names to the full list of names, then have the corresponding alphanumeric number in the adjacent cell to the full list, enter in the column beside the names in the partial list. To whomever helps with this, thank you!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
See this question and its answer. Seems to be like yours

https://ccm.net/forum/affich-46323-find-word-within-cell-put-value-in-adjacent#17