Vlookup woes

Steph_R
Steph_R ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to do a VLOOKUP and am getting the result #NOMATCH for all entries.

Essentially I want to look in the Instructor column in Sheet A, check Sheet B and find the Instructor name and return their ID number. The Instructor names are in the first column of Sheet B, like they're supposed to be, and the IDs are in the second column which I've referred to as 2 in the formula. If I use "false" I get the result #NOMATCH and if I use "true" it returns the same ID for all the names (and it isn't even someone in the Sheet A list).

my formula: =VLOOKUP("Instructor", {Instructor ID Range}, 2, false)

The Instructor ID Range is the first 2 columns of Sheet B.

Any idea what I'm doing wrong? I tried it in Excel and it worked perfectly. Thanks!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!