Return a column value based on choice in Stage column (same sheet)

Stacy M

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!

Christian Graf

Hello @Stacy M

Here is a nested If statement formula for your application.

You might have to change the exact case of the words and column names so they match your data, but the basics are here:

=IF(Stage2@row = "Identify", [Identify CR]@row, IF(Stage2@row = "delivery", [Deliv CR]@row, IF(Stage2@row = "closing by May31", [<May31 CR]@row, IF(Stage2@row = "closed past 6mos", [CL6mos CR]@row, IF(Stage2@row = "closing", [Closing CR]@row,"")))))

Hope this helps!