Match Two Sets of Data

[dkang2007]

Hi,

On one spread sheet I have a list of 900 customers' names and a corresponding industry code for each name.

On a second spread sheet I have another list of 300 customers names that includes some of the same customers from the first spread sheet. Is there any way to get the corresponding industry codes from the first spread sheet to the second spread sheet for the customers that are on both lists? How would I use the vlookup Function?

[spiwere]

It is pretty much doable. I'm assuming that the 300 names in the second sheet exactly match with the ones in the first. Do you have a spreadsheet with some sample data? It will help to better understand and help!

[dkang2007]

Here is the sample spread sheet. And yes the names match. Thank you for the help!

[spiwere]

Here you go...

I've placed the formula in column D of sheet 2:

Please Login or Register  to view this content.

Sheet attached.

Thanks,
Spi

[dkang2007]

Spi thanks for the fast response and solving my Excel problem.

I am curious to ask if it is possible to use the same formula but display the first 2 digits of the code?

[spiwere]

Paste this in column E "=LEFT(D3,2)" of sheet 2 and drag down. It should give you the expected output, and will keep it simple too....

[dkang2007]

Hi Spi,

Thanks again for your reply. You seem to be very knowledgeable in regards to Excel so instead of creating another thread, I am directing another question your way that relates to the previous question.

Attached, I have a sample spread sheet that includes Customer Name, Profit, Gallons and Codes.

I want to see how many times a specific code such as 62 appears. I would also like to generate a unique list of codes with sum the total profit and quantity for each unique code. Any suggestions?

[spiwere]

This can be easily done using "Pivots". See attached.

Column F gives you Unique Codes
Column G gives # of times a specific code appears in the list
Column H = Total profit
Colum I = Total Quantity

Going forward, I would request you to open a new thread for any new request.

By the way, I'm a learner too, and have learned some tricks through this lovely Forum, and people out here, just trying to contribute in my own way. I would prefer to call myself a student of excel.

Hope this is useful!

Thanks,
Spi