SOLVED

# I want to make a cell equal a value based on the value a type in another cell

Copper Contributor

# 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?

2 Replies
best response confirmed by quapple (Copper Contributor)
Solution

# Re: I want to make a cell equal a value based on the value a type in another cell

=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))

This formula returns the intended result in my example.

# Re: I want to make a cell equal a value based on the value a type in another cell

Thank you so much! I really appreciate the quick reply, you're the best.
1 best response

Accepted Solutions
best response confirmed by quapple (Copper Contributor)
Solution

# Re: I want to make a cell equal a value based on the value a type in another cell

=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))

This formula returns the intended result in my example.