Project Metadata Sheet

Samuel Dowdy Jr.
Samuel Dowdy Jr. ✭✭✭✭✭✭
in Formulas and Functions

=VLOOKUP(Month@row, [Month Vlookup]:[Month Vlookup], [Month Name]:[Month Name], false)

What am I missing? #INVALID DATA TYPE is what Im getting

· Share on FacebookShare on Twitter

Answers

  • jessica.smith
    jessica.smith ✭✭✭✭✭✭

    [Month Name]:[Month Name] needs to be a number representing the column position in the lookup table of the value you want to return.

    Jessica Selano

    jessica.selano@outlook.com

    · Share on FacebookShare 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!