Help w/Match or Lookup
 

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

Help w/Match or Lookup
 

in C2, place the formula below and then paste down as needed:
=VLOOKUP(B2,D:E,2,FALSE)

Spike9458 wrote:
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

Help w/Match or Lookup
 

JW,

Thanks! It works just as slick as warm goose $$it.

--Jim

On Nov 13, 8:15 am, JW wrote:
in C2, place the formula below and then paste down as needed:
=VLOOKUP(B2,D:E,2,FALSE)



Spike9458 wrote:
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- Hide quoted text -

- Show quoted text -