PLEASE HELP ME WITH FORMULA

[jacksonsmamma]

Ok, I'm going to describe this as best as possible.

In column F i have the title, "Food Authority" and in Column G I have the title, "Fowler".

I need in Column I a formula that will do the following:

If there is "Food Authority" in column F then i need it to show up in column I.

though, if column F is blank, but there is "Fowler" in column G then I need the title from column G to appear.

however the titles "Food Authority" and "Fowler" are just 2 of the 50+ titles that are in this spreadsheet.

Any help is greatly appreciated!

 

[NBVC]

You mean?

=If(F1<>"",F1,G1)


If not so simple, please display a sampling of your table with expected results.

 

[jacksonsmamma]

it worked!!

Great! It worked! I appreciate your help!! I'm not so great at the formulas, i'm so glad i used this website!!