I need an answer to an excel issue

[mikekennedy@triad.rr.com]

I am trying to rename items that I uploaded into my shopping cart on my website. At 1st I uploaded them with a name that wasn't descriptive enough so I down loaded the items back to my computer so I can rename the items. The shopping cart sends me a CSV file that is not in the original order that I uploaded in. Now I have an excel spreadsheet that is not in order with the existing spreadsheet that I have on my computer. Once I have created the new updated and more descriptive names now I must match them or replace them into the CSV file that was returned to me from my shopping cart. I think there is a simple answer but I am one of those excel dummy students. Basically I have 2 columns of data with the old name and another column with the new name that I created from the original upload sheet and I have another column of data from another spreadsheet that is a mismatched hodgepodge of data. Each cell in the CSV file is filled with the exact same data in the original file that I am calling the upload file. What I want to do is first, find and match the data in the CSV file and replace that data from the upload file with the new name that I have saved in the original upload file.


I don't know if I made this clear or not but maybe I did, we'll see.

 

[Luke M]

Sounds like a lookup problem. You've got a sheet that looks like this

[pre]

Old	New
abc	A1
def	B2
ghi	C3
and a hodgepodge sheet that has this

Main
ghi
abc
def

[/pre]
and now we need the new names placed in main sheet. First, we use helper column with a formula like:

=VLOOKUP(A2,[Book2.xls]Sheet1!A:B,2,FALSE)


This will give you the new names you need. Then, we can copy that column and do a Paste Special - Values. Then, cut and copy this data over the original column, and I think you'll have what you desire.

 

[nazmul_muneer]

@mikekennedy@triad.rr.com,

Please choose a short nick name instead of "mikekennedy@triad.rr.com". Also think and ask yourself before posting "will forum members understand my problem from the topic title?"


Regards,


--Muneer