Data validation list option to copy text from one sheet and paste in another

Copper Contributor

I have a data validation list set up in C2 on sheet 1. If an option is selected from the drop-down in C2 sheet 1, I would like the text in A2 sheet 1 to show in A2 sheet 2. Thanks!

1 Reply
Hi,

you can try this formula in A2, Sheet2:

=IF(NOT(ISBLANK(Sheet1!C2));Sheet1!A2;"")

Kind regards,
Martin