Help with VLOOKUP from another sheet
Im newer to Smartsheet and trying to find the correct way to have a 'summary' sheet that takes information from another sheet that we have. I have been trying to do a VLOOKUP but no matter how many videos i watch, i cannot seem to get it right. I want the 'Issue Description' on my Summary Sheet to show the text value from another sheet that has the same column name. Is that possible? One of my issues is [match_type], have no idea what to put there. Maybe this isnt even possible, just reaching out. Thanks!
Answers
-
actually, think i may have figured it out.
-
Hi Katie,
I'm glad to hear you've figured it out! If you're still having trouble it would be helpful to see a screen capture of your source sheet (blocking out any sensitive data) and a copy of your formula.
You may also want to reference a few other Community posts that go over similar topics:
Index/Match: https://community.smartsheet.com/discussion/comment/239115#Comment_239115
Join/Collect: https://community.smartsheet.com/discussion/comment/239080#Comment_239080
Cheers!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 381 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!