VLOOKUP help formula

Hello,

I am having issues with my formula and I could use some help! I have one sheet that I added a column called "Source" that is already listed on another sheet. Sheet 1 has all of the contacts and their sources and Sheet 2 is the one used now to track the projects for each of the contacts.

This is the formula I have:

=VLOOKUP([Site Name]@row, {Source}, 5, false)

I cam trying to have the column list the sources for the corresponding "Site Name" referencing the other sheet. What am I doing wrong?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!