Home |
Search |
Today's Posts |
#1
|
|||
|
|||
complex conditional formulas in excel using "IF"
i am trying to create a column in an excel sheet using multiple IF statements
IF the value in sheet5 column B = X, then go to sheet1 IF the value in sheet5 column B = N, then go to sheet2 etc Then Find the value in sheetX columnA that equals Sheet5 columnA corresponding to row of formula Retrieve the value in sheetX column C and enter it into this cell Then i want to copy the formula syntax for the enite column in sheet5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warnings when entering formulas in Excel | Excel Discussion (Misc queries) | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Complex Conditional formulas | Excel Worksheet Functions |