LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
making only specified columns visible [email protected] Excel Discussion (Misc queries) 1 April 6th 05 04:57 PM
Making list with unique columns Adam Excel Worksheet Functions 7 March 11th 05 09:21 AM
making used values fall from a list static69 Excel Discussion (Misc queries) 4 February 17th 05 02:04 AM
making columns automatically turn numbers into negatives Kathy Excel Worksheet Functions 6 February 1st 05 05:23 AM
Making Rows into Columns Tony Williams Excel Discussion (Misc queries) 1 December 2nd 04 03:47 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"