Ask Your Question

formula condition with text

asked 2019-01-31 09:32:19 +0200

Aminda gravatar image

hello! Is there possible to insert in B1 a phrase like "I want to visit Madrid" and get result in C1 "Spain", "I want to visit Rome" and get result in C1 "Italy"? Must mention that "I want visit Madrid and I want to visit Rome" are filter in calc completed with data validation.

Thank you very much!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-31 11:40:03 +0200

Aminda gravatar image

Any chance to make this happen? I've a spreadsheet with some text templates, when I want to select from templates B1 "I want to visit Madrid" and add text to it "I want to visit Madrid on 12th June", in C1 can remain sticked Spain? Thank you!!!!!!!!!! Hope some can help me.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-31 09:32:19 +0200

Seen: 61 times

Last updated: Jan 31 '19