G
Guest
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
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