Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Google Sheets: cell value based on another cell's multiple possible values (list from a range data validated)

Simple task: Cell A32 is a data validated to “List from a range” cell. In other words it’s a drop-down list cell with several pre-filled values (say, Alpha, Beta, Gamma, Delta). I want Cell B32 to check Cell A32 and return “$” value if A32 is only Alpha or Delta (here I’d like to be able to add as many conditions as I need, say return “$” if A32 is Alpha, Delta, Omega and etc.). If A32 is something else or blank – no value should be returned. How can it be done?

>Solution :

use:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

=IF(REGEXMATCH(A32; "(?i)Alpha|Delta|Omega"); "$"; )
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading