Retrieve a value from another worksheet

I'm new to Smartsheet and could use help.
I want to retrieve a Code Description text field value that exists in another worksheet (Code Master) that is based on a Code field that is in both sheets. Then concatenate them as; Code "-" Code Description. I thought a VLOOKUP would work, but not getting results.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!