Help if anyone can! ;-)

[tammymb]

I have a 3 column spreadsheet.

Column 1 has item numbers (About 3,000 of them) | column 2 has weights | MY COLUMN - column 3 has only item numbers I want.(About 1500 of them)

How do I find the item numbers that I have in column 3 in column 1 and delete the ones I dont want from column 1?
While keeping column 2 (the weights) matching the products in column 1

After I do that, I need to convert the weights from pounds to grams!

Can anyone help? ughhh I have no idea how to do this! Thank you for any help in advance!

 

[tammymb]

Hello! If anyone can help, I re-uploaded the zip file it is a csv now! http://www.bluedaisypress.com/help.zip I still need help trying to get this to work! Please!

Thanks

 

[mfexcel]

Did you follow the steps I suggest? If so, please tell me which part you get wrong?

Hi I sent you a message and uploaded the file to my server, so basically, If I look for my first item in column c, I can find it in column a to get its weight! I need to find all of the weights for the item numbers in column c! Does this make sense?

Thank you!

 

[Steph77]

The problem seems to be that not all the numbers you have in column C exist in column A

The ones you can see in this image returning #N/A are returning that because there is no identical number in column A