Return a column value based on choice in Stage column (same sheet)
I know this is super simple, but I have spent hours with various formulas and can't get it to work. Any help would keep me from pulling the rest of my hair out. Thanks!
Based on the choice selected in the Stage2 column ( choices are: identify, delivery, closing by May31, closed past 6mos, or closing), I want to pull a specific column value.
If identify, return value from "Identify CR". Or, if Stage2 says 'delivery', return the value in the "deliv CR" column.
Thank you so much!
Help Article Resources
Check out the Formula Handbook template!