INDEX Function | Smartsheet Learning Center
https://help.smartsheet.com/function/indexReturns an item from a collection based on provided row and column indexes
Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
VLOOKUP not working in a specific sheet of destination
Adrià Termes
✭✭✭
Hi all.
I am trying to do a simple VLOOKUP calling to a sheet as simple as the following one, wanting to get out of the Worker the Manager in the next column
Nonetheless, I am puzzled. When I open a new blank sheet and do the changes, the VLOOKUPS works perfectly, but in the following sheet, with exact same formula and trying both the "Created By" column and a dummy with the actual contact name, there appears as #NO MATCH. I tried many other things, but I cannot really know whta the issue is, as it works in another sheet.
Does anybody have any idea why is this the case, and if so, how can I solve it?
Thank you in advance!
Adrià Termes
Tags:
Best Answer
-
@Adrià Termes Have you tried using Index/match or index/collect instead of Vlookup? I find that combination more useful.
Answers
-
@Adrià Termes Have you tried using Index/match or index/collect instead of Vlookup? I find that combination more useful.
-
Hi @Razetto.
The formula per se does work, but the issue is that the automated column of Created By will never output the same contact structure (always an email, but not the name). I will try just setting up a forms and tell the people involved to input in either the column or in the Forms manually the name of the person, as the issue is common and no solution has been found now to make it automatic with the automation: https://community.smartsheet.com/discussion/83254/formulas-in-contacts-columns (this post shows a very similar issue).
Thank you for the advice!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 513 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!