Autofill Function

Question

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!

TVang · Accepted 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