Autofill Function
I have a reference sheet where there are "Show Codes" for each game from a Drop Down.
I have been trying to use the VLookUp formula but keep getting a #No Match in the column I'm attempting to have the autofill occur.
Images below - Basically I want the corresponding show code to autofill when a specific game is selected so for example: Preseason LA - Aug should fill in "SSTF.22.PHPC" from my formulas reference sheet.
Here is the formula I am trying to use:
=VLOOKUP([TNF GAME]@row, {Formulas Range 3}, 2, false)
Any help is much appreciated!
Best Answer
-
Hi, @Casey McKee , in your lookup table/sheet, move the TNF GAME column immediately to the left of the Show Code column. Your formula will work after doing this. The column being searched needs to be the first column in the range.
You can find documentation of Smartsheet functions here:
https://help.smartsheet.com/functions
Answers
-
Hi, @Casey McKee , in your lookup table/sheet, move the TNF GAME column immediately to the left of the Show Code column. Your formula will work after doing this. The column being searched needs to be the first column in the range.
You can find documentation of Smartsheet functions here:
https://help.smartsheet.com/functions
-
Thank you!! @Toufong Vang
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!