Help w/Match or Lookup

S

Spike9458

Hi All,

I have a workbook with a list of 4 digit codes as well as other
data, and another workbook with a list of 4 digit numbers in one
column and a name in the next column.

How do I set it up so that the name that appears in the second
workbook appears in a column in the first workbook, matched up with
the 4 digit code?

It looks something like this:

A B C D E
Name ID ID Company
Joe Smith 1234 1000 Humpty Dumpty
Jane Jones 1003 1001 Target
John Doe 1000 1002 Kohl's
Smitty 1001 1003 Burger King

In this example I want the company name in Column E to appear next
to the corresponding ID, for example make Humpty Dumpty appear in
column C next to John Doe 1000.

My list in column E goes from 1000 to 1400, with a unique name with
each. Column A has over 4500 with just the 4 digit ID, and I'm trying
to match it up to the company name.

Thanks to anybody that understands my question and can help!

--Jim
 

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