#Invalid Value in Index Match
Hi Smartsheets Community,
I am trying to write an index match that looks at a row that either says yes or no (only one column says yes) and return to me the corresponding value in the column below it.
I currently wrote =index([column name]#:[column name]#, match("yes", [column name]#:[column name]#, 0)))
I keep getting an "invalid value" as the result. The index and match range are the exact same columns, I'm not sure what I'm doing wrong. Does anybody know how to fix this?
Thanks!
Comments
-
I assume your example is generic and not really what you typed.
re: "The index and match range are the exact same columns, I'm not sure what I'm doing wrong."
This makes no sense.
This for the whole column
=INDEX([Column2]:[Column2], MATCH("yes", [Column2]:[Column2], 0))
or this for the first ten rows
=INDEX([Column2]1:[Column2]10, MATCH("yes", [Column2]1:[Column2]10, 0))
will return "yes" if it finds it, but won't give you any further information.
Are you looking for any instance of "yes"?
Craig
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!