I need help comparing 2 sheets

[madpammy]

I have 2 spreadsheets, June Inv File and Tim Car. I need to compare column A on both and when it finds a match I need it to copy column C from June Inv File to Tim Car. Any help appreciated.

md

 

[mancemonster]

Try...

=IF(ISERROR(VLOOKUP(A1,'[June Inv File.xls]Sheet1'!$A:$C,3,0)),0,VLOOKUP(A1,'[June Inv File.xls]Sheet1'!$A:$C,3,0))

Replace the 0 with whatever you want to be shown if A1 cannot be found in the other sheet.

Drag the formula down for each A you want to search for.


If you are in excel 2007 or later there is the ISERROR function that negates the need for the IF function.

Regards

Roger

 

[Desu Nota from Columbus]

can also use this: Change the range of A#:A# and C#:C# to match your data (if using Excel 2007 you can make it the entire column).

Place this in the C column where you want the value returned (in the Tim Car worksheet)

=SUMPRODUCT(--('Jun Inv File'!$A$1:$A$30=A1),'Jun Inv File'!$C$1:$C$30)

change range to suit your data!!