How to reference column name pulled from formula

mwat4482

I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from?

My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should pull the value from Day 0 Start3 Date. Instead, it's pulling the text "Day 0 Start3 Date". Can I have the column name be used as a string instead of text?

="[" + INDEX([Index Date Row]:[Index Date Row], MATCH(Index@row, [Index Lookup]:[Index Lookup], 1)) + "]@row"

Thanks!

Paul Newcome

Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of

=INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)

You are going to need to update the column names in the formula to match what you are using in your sheet.

Paul Newcome

Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of

=INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)

You are going to need to update the column names in the formula to match what you are using in your sheet.

mwat4482

That worked, thank you!

Paul Newcome

Happy to help. 👍️