Return value from specific columns based on input

Don Wyma

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.

Don

Don Wyma

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.

Thanks,

Don

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.