Max,
I dont think it would work because as he said, sheet1 ColA and sheet2 ColA
have the same data but not necessarily located in the same row. Sheet3
should scan Sheet1 ColA and sheet2 ColA for a match and if exists storing it
in sheet3 summing ColC of the match. Im not sure Excel can do this.
Cheers,
Emilio

"Max" escribió en el mensaje de noticias
...
My thoughts would be to copy n paste Sheet2's data below Sheet1's (assumed
identically structured), then pivot on the combined source, placing col
A's
header into ROW area, "Price" into DATA area (SUM). Just a couple of
seconds
worth of effort, and it should yield the desired results.
--
Max
Singapore