• For starters I'm very green at excel..

In spread sheet 1 I have a list of part numbers in column A and the prices in column C.

In spread sheet 2 I have the same part numbers plus some new ones spread through out in Column A and the new pricing in column in column C.

Is there a way to match up the part numbers and put the new pricing into column C in the 1st spread sheet.

I have worked with a few things in excel but this is way above me.

Any help is welcome

My son inlaw said this should work but something is not quite right.
=SUMPRODUCT((U\$1:U\$8=[Book2.xls]Sheet1!\$A2)*([Book2.xls]Sheet1!\$C2))

steve

In spreadsheet1 I would use a VLOOKUP in a blank column and then copy the values over to column C. Assuming you want to maintain the costs in column C if there's no match in spreadsheet2, use something like this in spreadsheet1:

Code
``=IF(ISNA(VLOOKUP(A1,[spreadsheet2.xls]sheet1!\$A\$1:\$C\$300,3,0)),C1,VLOOKUP(A1,[spreadsheet2.xls]sheet1!\$A\$1:\$C\$300,3,0))``

Does this help?

Barrie Davidson
My Excel Web Page
"You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Sorry I didn't see your replay before I edited my first message. I will try what you sugguested.

My son inlaw said this should work but something is not quite right.
=SUMPRODUCT((U\$1:U\$8=[Book2.xls]Sheet1!\$A2)*([Book2.xls]Sheet1!\$C2))

steve

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!