Vlookup or Index Match look up help
Hello,
I feel like this is an easy question, but I have been struggling to find the answer in a way I can understand.
Basically, I need to use a vlook up or index/match based on 1 cell and have it return a list.
Screenshot attached for reference. I have one document that has the data and certain columns have formulas to flag certain things. Another sheet will feed into a dashboard and I need to make it easy for someone to flip between what they are looking for.
For example.. they will need to see a list of all of the cells in the primary column that has the word "New-2" or "New-1" in a corresponding column. Does that make sense?
A filter option will not work as this needs to populate on a separate grid which will feed into a dashboard.
Answers
-
Curious, wouldn't it be better to create a report that has the fields and filter looking for field New-1 = "New-1" AND field New-2 = "New-2"? You could then easily display the report on the dashboard.
-
I can go ahead and try using the report feature however I would very much like to see about a list being made as I do need some of the data numbers and from my understanding reports don't work as well to make graphs for dashboards?
But I will give the report feature a try and see if that can solve half of my dilemma. :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!