Excel Formula

 J -

Is there an Excel Formula that can be used for the following:

If Column F = Name and Column G and/or Column H Does NOT = Name or is NOT Blank, then Replace Column F with Column G OR Column H

1 reply

well j
your question is not quit clear can u please make it more clear
I am working on an Excel Spreadsheet and within Columns F, G, H, & I.
Everytime Column F is SC and Columns G, H, or I have anything but MB then I need to put one of from the 3 columns into Column F to replace SC.
This is my email.