SOLVED

Trying to make a column fill in based on another column

Copper Contributor

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 espresso. Right now I have kitchen cabinet color in column F and the bathroom color in AA.

2 Replies
best response confirmed by GKruzy (Copper Contributor)
Solution

@GKruzy 

In AA2:

=F2&""

or

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

Fill down.

@Hans Vogelaar  Thank you so much! That worked and now I have one less column to fill in!

1 best response

Accepted Solutions
best response confirmed by GKruzy (Copper Contributor)
Solution

@GKruzy 

In AA2:

=F2&""

or

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

Fill down.

View solution in original post