How to pull information from one sheet to another

I have seen a lot of questions about this and I can't seem to figure it out. Super frustrating as it seems it should be very simple. I have tried multiple variations of VLOOKUP and it doesn't seem to work. I am wanting to return the value of a row into another row. Whatever is in there should be returned. This is the example of what I typed. I want it to look in the row that is labeled Team Member, on the sheet L&D Content Creation Submission. If something is there I want it to return the value in that row, if not then false. What am I doing wrong?!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!