Copy Data from one cell to another only if a certain drop-down option is selected

Amanda Hoffman

What formula can I use or what option do I have if I want one cell data to be copied to another cell only if a certain drop-down selection is chosen? Example: the is an amount in one cell. I want that amount to be copied to another cell only if the drop down selection of Approve is selected. If not, nothing is copied.

Paul Newcome

You would use a formula along the lines of

=IF([Dropdown Column Name]@row = "Approve", [Amount Column Name]@row)

Paul Newcome

You would use a formula along the lines of

=IF([Dropdown Column Name]@row = "Approve", [Amount Column Name]@row)

Amanda Hoffman

Ok, thanks. I will try it out!

Paul Newcome

Happy to help. 👍️