Formula to pull values from another sheet based on another column


Hi everyone!

I need some help pulling a value from Sheet A Column 2 to Sheet B Column 2 if Sheet B Column 1 is the same as Sheet A Column 1.

In my example, I want the use cases to populate based on the use cases in the master sheet if the collateral ID is the same.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!