Vlookup

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

Date between dates to return the date in cell
Hello, I am struggling with one of my formulas: =IF(AND([Start Date]@row, >=DATE(2020, 10, 1), [Start Date]@row, <=DATE(2021, 9, 30)), [Start Date]@row, IF(AND([End Date]@row, >=DATE(2020, 10, 1), [End Date]@row, <=DATE(2021, 9, 30)), [End Date]@row)) If the start or end date falls between the dates in the AND statement, I…
How to create a stacked column chart from a report
Hi everyone, I'm trying to create a staked columns chart in my dashboard to show per Assigned to the number of cases per status. However, the chart shows up just as 1 big column. Would someone knows why? Please see the photo for visual. Thank you in advance for your help
Linking Parent and Child Rows with a Unique Identifier
Looking for a way to tie Parents to Children with a numeric value, so if they become separated and lost in a sort, they can be easily found and nested under the correct Parent again. We have an automated [ROW ID] column to reference. We created a [SLIP ID] column and used =PARENT([ROW ID]@row), and it does populate the…