Excel question!

[SpeckledJim]

I'm sure this is straight-forward but I don't have a clue how to do it.

2 files. The first contains lots of columns of product data, including one column labelled SKU

The second file includes just 2 columns - SKU and Item number.

The first file contains all of the same items as the second file, and a lot more that are not contained in the second file.

My task (your task!) is to add the item number (from file 2) to a new column matching the corresponding SKU in the first file.

Thousands of lines, so I can't do it manually.

Any help gratefully received!

TLDR - SKU is the common key, I need to move a correlated piece of data (item number) from one file to the other.

[SpeckledJim]

Sadly 50,000 lines in this sheet, and another 250,000 to go after I've cracked how to do this, so I can't do the C&P route.

There are as many hits as misses and they are randomly scattered through the data, so the sort will not line-up.

Thanks though.

[SpeckledJim]

Thanks, sounds like VLOOKUP is my friend. I'll go for a play and see if I can do it.

Ta!

[SpeckledJim]

BACK OF THE NET!!

Thanks a lot everyone. My afternoon has just switched from frustration and angst to boredom and ennui.

And that's a big result.

[SpeckledJim]

Thanks. Once the data was across in the master file I copy and pasted values only to 'lock' it in.

I knew what I wanted to do but couldn't find a concise enough way to get google to help me.

PH delivers - thanks all.