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
-
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
-
When I first started working on formulas across sheets, I hadn't realised I needed required permissions.
Once that was fixed, I then realised I needed to click on the Reference Another Sheet when building the formula, rather than just typing the curly brackets around the sheet name.
Let us know if this experience doesn't help you, or if you're still getting the error message #INCORRECT ARGUMENT SET
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
I actually created both sheets so I am admin on both, and I do click reference another sheet for this, and still getting #INCORRECT ARGUMENT SET unfortunately. :(
-
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)
-
That did it!! Thank you so much Hollie!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!