VLOOKUP return the second value that is finds in the table
Hi,
I am looking for a formula that can return the first, second, third ... value in the table.
Using Vlookup will only return the first match
Any suggestions!!
Thanks
Fadi
Comments
-
It depends on how you are setting your criteria. Can you give more details and maybe include a screenshot after manually entering the data in the way that you would like it to appear?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi, I am after this function at the moment, but I don't know how to do it. I have a checkbox column, that when it is checked in one sheet I would like it to be pulled through to another. I have done a vlookup to do this but it on but it only returns the top value, is there a way to pull out all of the ticked check boxes in the sheet (without a report)?
Thanks
-
That's going to depend on the details and how everything is set up. Are you able to provide some screenshots?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
This is the sheet I want to take the lines from, so on the left are the check boxes and I need to pull them all into one sheet (not a report)? Is there a way to do this please?
-
Hi Claire,
Can you describe your process in more detail? What do you want to do with the information?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi,
I have one sheet that people fill in with requests from clients. Sometimes some of these requests need to be repeated and we want to track these lines in one place (other than the master sheet) and then calculate our metrics from this, this is why I would like it in a sheet rather than a report.
Is this enough detail?
Thank you,
Claire
-
Thanks!
Can you share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic day!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!