Forum Discussion
Solved
I want to make a cell equal a value based on the value a type in another cell
Happy new year!
I have a list of funders in a column and there are two types of funders: you're either Ontario Health (which is classified as a Fund Type 3 funder) or you're anything else (which we classify as a Fund Type 2 funder). I want to be able to type (or select from a drop down) in one cell the funder and then the cell next to this cell to automatically populate with the text "Fund Type 3" or "Fund Type 2" depending on if the funder selected in the first cell was Ontario health or anything else. Can I do this with conditional formatting or formulas or do I need VBA?
=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))
This formula returns the intended result in my example.
=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))
This formula returns the intended result in my example.
- Thank you so much! I really appreciate the quick reply, you're the best.
