Forum Discussion

GKruzy's avatar
GKruzy
Copper Contributor
Jul 13, 2022
Solved

Trying to make a column fill in based on another column

I am filling out a spreadsheet for cabinet colors so if the kitchen color is white, then the bathroom color will be white as well. If the kitchen color is espresso, the bathroom color will be espress...
  • HansVogelaar's avatar
    Jul 13, 2022

    GKruzy 

    In AA2:

    =F2&""

    or

    =IF(F2="","",F2)

    Fill down.