Can you do a VLookup from a Drop Down column

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!