Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

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

Copper Contributor

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? 

Screenshot 2024-01-02 131135.png

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

@quapple 

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

 

This formula returns the intended result in my example.

fund type.png

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

@quapple 

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

 

This formula returns the intended result in my example.

fund type.png

View solution in original post