How to pull information from one sheet to another
I have seen a lot of questions about this and I can't seem to figure it out. Super frustrating as it seems it should be very simple. I have tried multiple variations of VLOOKUP and it doesn't seem to work. I am wanting to return the value of a row into another row. Whatever is in there should be returned. This is the example of what I typed. I want it to look in the row that is labeled Team Member, on the sheet L&D Content Creation Submission. If something is there I want it to return the value in that row, if not then false. What am I doing wrong?!
Answers
-
In the past I've ran into issues using Vlookup which is why I now prefer the index/match combo. Try something like this: =index({L&D Content Creation Submission},match(Team Member@row,{Team Member},0))
More on the index function here: https://help.smartsheet.com/function/index
-
Did not work, says #UNPARSEABLE.....
-
Hi @Paul Mangan
I hope you're well and safe!
Here's the structure for an INDEX/MATCH combo.
=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I'm sorry I guess I don't understand. I am 2 days into SmartSheet and it's really frustrating coming from excel. I understand formulas in excel but not in SmartSheet.
-
Column names that have spaces, numbers and/or special characters should be wrapped in [square brackets]. Also be sure to make sure column names used in formulas match exactly the column names used in the sheet. The easiest way to do this is to click on the cell within that column to automatically generate the appropriate reference.
=INDEX({L&D Content Creation Submission}, MATCH([Team Member]@row, {Team Member}, 0))
-
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!