Index Match from Column to Row
Answers
-
Hi Vinton,
Your Index match is formulated incorrectly, but either way I'm not sure that will get your job done.
In the column you have the index match in in your screenshot, which value are you trying to return? Just so I can understand your intended relationship between the two sheets.
I'm passionate about helping you leverage the truly awesome power of smartsheet!
-
Thanks for responding. I am trying to return the results from the measurable elements sheet, i.2 Fully Met, Partially Met, Not Met and N/A. The results from that identified column of the measurable element sheet should be in the same order from left to right in the row of the incoming sheet.
-
IF I am understanding what you are trying to do your formula you look like the
=INDEX({Status}, MATCH("ME 1", {Measurable Elements}, 0))
You would have to change the "ME 1" to ME 2" in to match each column name
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!