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
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Edu07" wrote:
Sheet 1 column A is alphanumeric, B is text and C is price, Sheet 2 has the
same condition. In sheet 3 I'd like to check Sheet1 ColA and Sheet2 ColA if
is equal then Store alphanumeric data in Sheet3 ColA and Sum Price (sheet1
colC + sheet2 colC). Pls note that there're over 1000 entries in each sheet
and data in sheet1 ColA Row 10 is not necessarily equal to sheet2 ColA Row10
but may it be in Row150.

How can it be done using IIF Statement?