View Single Post
  #1   Report Post  
Jamie Furlong
 
Posts: n/a
Default Matching values from two columns and making a third column with the results - possible?

I have a list of products in an Excel/CSV table
I've been given a disk with images for about a 2/3 of the products in the
table.
Fortunately, the images match the product code, mostly.
Thing is, there's 5,000 products, and I'm a bit stuck on how to match the
two up side by side.
I can make it so I end up with a simple list of the image names, and a
simple list of the product names.

SO, let's say I had the following columns

A is a list of products
B is the image name for that product, if it exists (ie: matches)
C is a list of images

So hopefully, there's some function that will make me end up with the
following (I just know this isn't going to line up!)
A B C
123 123.jpg 789.jpg
456 123.jpg
789 789.jpg 456.jpg
234 354.jpg
345 345.jpg
456 456.jpg
I can strip off and then replace the .jpg extension if needed, also not all
the product codes are the same length, and include alphanumeric characters
as well as hyphens, but fortunately no apostrophes.

Would really REALLY appreciate someone pointing me in the right direction
here! Thanks.
PS - if this is not possible in Excel, is there anything else that might do
this?