Vlookup not working across sheets

Hey all. I'm trying to pull info from one sheet to another if two cells match and getting #INCORRECT ARGUMENT SET. Any help would be greatly appreciated!

=VLOOKUP([Opportunity Name]@row, {PMO Capacity Opportunity Name}, 21, false)

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓

    I have discovered that index(collect seems to work much better when using cross sheet references as even if someone moves a column it still pulls in the data you want.

    =Index(Collect({PMO Capacity Opportunity Name},{PMO Capacity Opportunity Name},[Opportunity Name]@row),1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!