Vlookup with Large formula as the search value

Walter Mootz
Walter Mootz ✭✭✭✭
edited 12/23/20 in Formulas and Functions

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!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!