update contents of column by comparing two other columns

[stratchy]

Hi,
I need help with trying to perform the following opearation in excel:

I need to update the prices of items in my inventory when my supplier gives me sends me a new pricelist. I need to build a macro I believe that will compare Item Codes in My Pricelist with Item Codes in New Pricelist and is there is a match, then it will update corresponding price of that item in My Pricelist.
I am at a loss, and would really appreciate help...

 

[VoG]

You should be able to use VLOOKUP for this. See http://www.contextures.com/xlFunctions02.html

 

[stratchy]

You should be able to use VLOOKUP for this. See http://www.contextures.com/xlFunctions02.html

hi,
I had a look at that link - thank you. However I am unsure as to how to use the look up table to update the information in the table.

 

[VoG]

Using a copy of your existing worksheet, you would insert a new column and add the VLOOKUP formula.

You could then copy the new column and use Edit > Paste Special > Values to copy over your old prices.