Solved Get data to move from one sheet to another?

August 16, 2011 at 13:22:43
Specs: Windows XP
I have a worksheet with item numbers from our US site, and a ton of other data. On another sheet I have the Item numbers from Mexico, and the corresponding US item numbers. What I am hoping to do is to have a formula to autofill the corresponding Mexico item numbers into a blank column on the primary worksheet. I have no idea how to do this, but I know doing it manually is going to take *forever*. Is there a way to have excel refer to another sheet to pull the correct item number across to make one complete data sheet?
Ex: US Item# 10034
Mexico item #: HR52

See More: Get data to move from one sheet to another?

Report •

August 16, 2011 at 15:03:12
✔ Best Answer
Read up on the VLOOKUP function in the Excel Help files and see if that works for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 23, 2011 at 14:47:29
VLOOKUP was exactly right, thanks VERY much. I even found a very step-by-step guide:

Report •

Related Solutions

Ask Question