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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!