reading values between 2 spread sheets

    For starters I'm very green at excel..
    I have 2 spread sheets.


    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

    Re: reading values between 2 spread sheets


    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

    Re: reading values between 2 spread sheets


    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!

Register Yourself Login