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

Options

Answers

Paul Newcome ✭✭✭✭✭✭

04/14/20 Answer ✓
Options
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

New Sheet Not Showing up in Existing Report
I have a folder and inside the folder I have 25 sheets and a report that produced a listing of all the sheets in that folder, somehow when I add a new sheet in that folder, the new sheet doesn't listed on the report. Please help. thank you.
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!

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

Watch video

Using the v-look up function

Answers

Categories