I would like to learn how to compare a row in Workbook1 against a range of
rows in Workbook2. If one of the rows in Workbook2 is the same as the row in
Workbook1, data from a cell in Workbook2 is then copied into an empty cell in
Workbook1. For example:

Workbook1 Columns
A=Name, B=Part, C=2005_Price

Workbook2 Columns
A=Name, B=Part, C=2004_Price

If a row in Workbook1 with columns A & B being exactly the same as ONE of
the many rows in Workbook2 (columns A & B), I would like to copy the info in
Workbook 2, 2004_Price, into column D of workbook1. Thus, when formula is
completed, Workbook1 should look like this:

Workbook1 Columns
A=Name, B=Part, C=2005_Price, D=2004_Price

I've tried VLookup and If, but can't get it to work. Your expert advice
please.