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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!