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

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!
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top