Conditional Text

k.holmes.35

Hello!

I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the word "cat"

Is that a type of function or can I adjust the conditional formatting to make that work?

Carson Penticuff

You wouldn't be able to do this with conditional formatting, but you can use nested IF statements in your second column. This can get a little complicated if you have many options though. Here is an example for the case you present:

=IF([Breed]@row = "St. Bernard", "Dog", IF([Breed]@row = "Maine Coon", "Cat", "")