Hello, I am trying to use this formula, =VLOOKUP([Facility ID]1, {Data Control Range 1}, 3, false) and it continues to come up no match or incorrect argument set, is there anyone able to help figure out whats going on here?

There it is... You are only selecting 2 columns, but you are telling the formula to pull from the 3rd column. Change the 3 to a 2 and see what that does for you.

It worked! Thanks so much... i have tried changing between a 2 and a 3 previously but never thought multi-select would be an issue! Really appreciate it

Happy to help! 👍️ Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.

Using the v-look up function

Answers

Paul Newcome ✭✭✭✭✭✭

04/14/20 Answer ✓

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
1 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

How Do I Illustrate Checklist Data in a Dashboard?
I am making a dashboard widget to show how many items in the implemented mitigations column are checked and how many are not. I understand that I may need to make a report or a sheet summary to do so first. How can I make this happen? Also, at some point, I'd like to show a relation to, if it is implemented, is the…
Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
Can I use a condition to remove a user from receiving weekly notifications on an automation?
I have a weekly automation set to send to everyone in my 'owner' column. As each owner completes their assignment, they no longer want the weekly reminder to do their work. How can I remove them and keep the rest?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Using the v-look up function

Answers

Categories