Extract the "price" for 400 "codes" (or item numbers) from a worksheet containing up to 15,000 "codes,prices"

OS: Windows XP; MS Excel 2007

I need to update the "price" for a corresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the corresponding "Price" is in another column in the same row. I need about 400 items updated and I don't want the other 14,600 data.

I have a worksheet with the 378 "Codes"

http://rapidshare.com/files/243217967/CPTCodes__378codes___this_is_the_filter_.xlsx.html

and I want to pull the new "price" for these 378 "Codes" from another worksheet (that does not match the first worksheet in size or layout)

http://rapidshare.com/files/243223322/New_Code_and_Price__this_is_the_source_.xlsx.html

seems simple enough?

Hi, 

I guess you have to just use vlookup and you will be able to get the value which u are looking for from the other sheet. 

Regards

Mathew

Thanks for the feedback, I figured it would be a vlookup but have had quite a difficult time getting it to work right

Here is what I have come up with so far

=VLOOKUP(A2,NewCode!$A$2:$B$253,0)

"NewCode" referes to worksheet2

I am not sure how to handle duplicates with this yet but one thing at a time, right...