Return value from specific columns based on input

I am looking for help with a formula. Based on the input in one cell (Column A), I'd like to return the value from one of six other cells in the same row (Columns B-G) based on the specific input in Column A. I am getting stuck on how to set this up. Column A will always have the same 6 potential inputs that would lead to a different cell being returned in my equation column.

Thanks in advance for your help.



  • I may have brute forced fixed it with multiple if statements that point to different columns.

    =IF([Next Phase]@row = "Lead Generation", [Proj LG]@row, IF([Next Phase]@row = "Lead Optimization", [Proj LO]@row))

    I'd be happy to hear if there is a more elegant way to do this.



  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Don Wyma

    Hope you are fine, you can do that by creating a table of your inputs and use Vlookup or Index with Match functions to do that and select the input automaticly.

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!