Hi Smartsheet community!
This may seem like a simple question but I cannot figure out this formula for the life of me.
I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2.
On sheet #2 it will be a list of alias's and their matching level.
Sheet #1: (raw data no formula)
Sheet #2: (VLOOKUP Sheet)
I am needing the VLOOKUP formula to pull the level listed on sheet #1 and match it to the alias on sheet #2.
I keep getting error messages back and I cannot figure out what I am doing wrong.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!