I am an extreme beginner when it comes to Excel programming, so I was wondering if someone could help me.
I am getting a CSV file from a web site which has columns of text values. Let's say one has A-Z. I have a worksheet that has 2 columns where if a1 is the value A, A2 is Andrew, b1 = B, b2 = Bob, c1 = C, c2 = Charlie, etc. I need a formula that will read the values that come in a column of the CSV file, compare them to my list in the worksheet, and return the value in the column next the list of A-Z. They're actually product SKUs and descriptions, I've attached a jpg that might help describe what I'm trying to do.
Any help or pointers would be greatly appreciated.
Thanks!
Bookmarks