Vlookup with Large formula as the search value
Walter Mootz
✭✭✭✭
SOLVED* REALIZED THAT I HAD AN EXTRA ) IN MY FORMULA!!!
Hello everyone,
I have a list of items that pull from other sheets what we're spending on each one. From there, I have used the large function in a cell to pull the largest totals and rank them from 1 to 5 for a "top 5 spender list"
I would now like to pair up what the item's physical name is in this list to correlate with the Spending totals so I can create a metric in a dashboard.
I built a vlookup formula containing the large function as the search value but I'm getting an unparseable error.
Here's a screen shot of the formula and its reference cells
Any help is greatly appreciated!!
Tags:
Answers
-
Hey @Walter Mootz
So glad you were able to figure it out! 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 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!