How to reference column name pulled from formula
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!
Best Answer
-
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.
Answers
-
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.
-
That worked, thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!