Replacement in excel... (or is it substitute)

  • Thread starter Thread starter Josh the man
  • Start date Start date
J

Josh the man

I have two excel spreadsheets, one with numbers that
correlate to names of companies, and another that only has
the numbers on it. I need to replace the numbers on the
second sheet with the corresponding names on the first
sheet, is there a function, or some other method i could
use to do this? thank you so much for you help!
 
Josh,

Do you mean VLOOKUP.

Alongside the numbers, in a new column, add
=VLOOKUP(A1,other_sheet!A1:B100,2,FALSE)
or similar to pull back the name.
 
Back
Top