Vlookup formula

Samuel Dowdy Jr.

Samuel Dowdy Jr. ✭✭✭✭✭✭

08/25/21 in Formulas and Functions

I need help with a formula

=VLOOKUP([Employee Name]@row, {Payroll VLOOKUP - Employee Number Range 1}, 2, false)

What am I missing? Im getting #incorrect argument set

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

08/25/21

Which column(s) is your cross sheet reference pointing towards?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

How can count items in a multi-select column?
I have a project sheet with status and a multi-select column that lists the area(s) each project is for. I have created a metrics sheet to calculate the number of projects per status per department, however, the columns that have more than one department listed is not being counted. What I am looking for is something like…
CountIfs results 0
My sheet currently has a formula tracking # of job submissions - formula had been working up until today. It now results in zeros - I'm thinking it might be the year change however original formula uses the date of Today for year and month so I'm not certain the year is the problem. Formula below - any suggestion would be…
Need another set of eyes on SUMIFS formula in Sheet Summary
Hi and Happy New Year, Hope all is going well for you. In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSABLE. I haven't been able to figure it out all day. Appreciate any input you may have! Goal: To sum the values in the ARR…