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

%3CLINGO-SUB%20id%3D%22lingo-sub-2884342%22%20slang%3D%22en-US%22%3EData%20validation%20list%20option%20to%20copy%20text%20from%20one%20sheet%20and%20paste%20in%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2884342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20data%20validation%20list%20set%20up%20in%20C2%20on%20sheet%201.%20If%20an%20option%20is%20selected%20from%20the%20drop-down%20in%20C2%20sheet%201%2C%20I%20would%20like%20the%20text%20in%20A2%20sheet%201%20to%20show%20in%20A2%20sheet%202.%20Thanks!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2884342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905344%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20list%20option%20to%20copy%20text%20from%20one%20sheet%20and%20paste%20in%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905344%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3Eyou%20can%20try%20this%20formula%20in%20A2%2C%20Sheet2%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIF(NOT(ISBLANK(Sheet1!C2))%3BSheet1!A2%3B%22%22)%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EMartin%3C%2FLINGO-BODY%3E
Occasional Visitor

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