Can you do a VLookup from a Drop Down column


Hey there! I am trying to create a VLOOKUP for an assigned task based on a person's role. It says "Incorrect Argument" Is this because the reference row is a drop down list?

Thanks! Marlo


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!