Cell value changed

Juan Garcia

I would like help with the following:

I wish for a cell value to change to the same cell value of another cell based on what a third cell value is.

For example: First cell value is a dropdown in which I select Sold. Because I selected Sold I want a blank cell value to automatically be populated with the value on another cell which already had a number in.

Who can help me?

Faaez Kamaal

Try this;

=IF([Column 1]@row = "Sold", [Column 3]@row, "Not Sold")

Make changes as necessary to match your sheet, but that should get you started.

Juan Garcia

Thank you

=IF([Column 1]@row = "Sold", [Column 3]@row, "HERE")

I want HERE to be the value already in another cell in the sheet.