Vlookup and automated number column
I have a Vlookup function in one column and I have it set up to return information when certain criteria is met by selecting information from an adjacent cell. If no selection is made in the adjacent cell or in the rest of the row, my auto-numbering column still populates a number even though the entire row does not contain any information. Is this caused by the Vlookup function trying to search for its specified information? How can I stop the auto-numbering column from populating? I have also tried nesting the Vlookup function with the IF(AND function to meet additional criteria before the Vlookup function searches for its information.
Comments
-
Hi Tom,
The auto-number will be added when a new row is added, and it doesn't have to be visible information (change of color) It can look empty, but there still is something on the row.
Hope that helps!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives