Excel vlookup help

Help!

I have just spent the last hour and a half on the internet looking for a concise explanation of writting a vlookup command in Excel and can't find what I need. I did, however, find you kind folks exchanging information on how to do lots of things. I'm hoping you can help me. I have done vlookups before, but don't use them frequently enough to remember from one time to the next how to write the formula (arghhhhh! ! ! ! ! - learning vlookup is NOT like riding a bike).

I have 2 separate spreadsheets. Each spreadsheet is named (obviously) and the worksheets on each are also specifically named. My part numbers, descriptions, etc. are common to each. Spreadsheet #1 has a blank column that wants my new prices for 2004. Spreadsheet #1 has those prices.

The part numbers, that must match exactly, are in column A on both spreadsheets. Can someone tell me how them vlookup formula will read to do this? I'm confused with the part about how to tell it to find the information on one spreadsheet and bring the answer over to another. I am so frustrated right now!

Thanks for any and all help.

Lisa

I find some web link.Hope it's helpful to U!
http://www.exceltip.com/st/VLookup_..._Excel/535.html
http://www.personal-computer-tutor.com/vlookup.htm