Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Q: IIF Statement
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |