Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making only specified columns visible | Excel Discussion (Misc queries) | |||
Making list with unique columns | Excel Worksheet Functions | |||
making used values fall from a list | Excel Discussion (Misc queries) | |||
making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
Making Rows into Columns | Excel Discussion (Misc queries) |