Another Formula not working
BrendonL
✭✭
Hi again,
Im having an issue where im doing an index match on 2 columns across 2 sheets. I have double check the email that the index match is matching to and from. I am not sure why the index match is only picking up 2 rows and not values from all of the rows.
I've tried doing manually putting in the email in the blank row, but it still is empty and I've copied and pasted the emails to make sure they were the same across sheets but still same error.
Tags:
Answers
-
Add zero after Range 3}
=index({VSB Range 1},match([Volunteer…],{VSB Topics…},0))
...
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives