Vlookup

Options

Samuel Dowdy Jr.

Samuel Dowdy Jr. ✭✭✭✭✭✭

01/13/25 in Formulas and Functions

=VLOOKUP([Update Type]@row, WEEK@row, YEAR@row, {AR / AP Master Sheet Critical}, false)

Whats wrong with this formula

0 ·

Answers

Melissa Yamada ✭✭✭✭✭✭

01/13/25

Hello @Samuel Dowdy Jr.
The multiple search values ([Update Type]@row, WEEK@row, YEAR@row) will cause you a formula error.
If you need to look at multiple criteria you might want to use an INDEX/ COLLECT formula instead.
https://help.smartsheet.com/function/index?_gl=11he1p1v_gcl_auMTkwNTg0MzEyNi4xNzM2MzM1NzAw_gaNzIwNjM3MzM1LjE3MzYzMzU3MDA._ga_ZYH7XNXMZK*MTczNjc3OTkyOS4xMS4xLjE3MzY3ODA5OTIuMjUuMC4w

Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a best practice to convert a dashboard to a PDF?
I've been asked to see if there's a way to make saving a dashboard as a PDF more accurate. I've tried printing/saving as a PDF. Is there a setting so that the area that I have for a list can expand? If our area is too small, then we don't see the entire list. And if we make the area large enough to always contain the…
Autopoluate date information to another cell
I would like to autopopulate a cell in another column with the first 3 letters of the month and the last 2 digits of the year that are in the date column that are now displayed as 07/01/25. Thank you in advance for sharing your wisdom!!
Formula not working - correctly
I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets. I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports…