Referencing a Lookup Table
I am rather new to Smartsheet formulas. I am trying to reference a lookup table column. Please see screenshot.
In the main table, I would like e.g. "MM" to autopopulate when Mickey Mouse is entered in the FULLNAME column.
Whether I try VLookup or Index/Match in the FULLNAME column of Main Table, I receive errors. I am sure that it is a simple fix.
Any assistance would be greatly appreciated. Thanks, Therese Murphy