Hello,
I have limited experience with excel's if,then statements. I believe I need a nested IF statement or an IF(AND) statement.
I am trying to grab numerical values from one sheet to another based on what is in columns A and B from another sheet so that:
[IF column A(sheet 1)=same text in column A (sheet 2)] AND [IF column G(sheet1)="Operational"] then return the value in column C(sheet 2)
Thanks for the help!
Bookmarks