Hi,

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?

TIA

Edu