VLOOKUP - random responses

Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Good evening,

    Add ", False" to the end of you VLOOKUP formula.

    =VLOOKUP(components@row, {CQ Dec........}, 2, False)

    Fix the problem?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!