Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

formula condition with text

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!