Transferring Info from One Excel Sheet to Another

Hello!

Here is my situation:
On my first Excel sheet, I have the name of the product, the code for the product, and a blank column for the price of the product.
On the second sheet, I have the code for the product and the price of the product.
Note: The information in the two excel sheets are not in the same order.
Since both worksheets have an identic column (the code for the product), is there someway I can have the info for the price of the product in the second sheet automatically transferred to the first sheet using that similar column. If not, is there anyway I can have this info automatically transferred. I do not want to do this manually. Please help! This is urgent! Please tell me to be more specific if necessary.

Thanks!

Have you tried the VLOOKUP function? It will work for you if your second sheet is sorted in alphabetical order.

Post your workbook if you like, without confidential info and I can put together a formula for you.

Diana

From what I understand, your 2nd sheet is kind of Master Sheet with the Data of Product Code and Price and you want to get the Price for the Product Codes in 1st sheet.

So, use Vlookup function:vlookup(A2, Sheet2!$A$1:$B$100,2,0)

Use this formula in the price column on sheet 1, assuming your product code is in Column A in sheet 1 and your data starts from A! in sheet 2 and ends at B100.

Thanks for the help everyone! I used the VLOOKUP function and it worked well.