Formula to pull values from another sheet based on another column

Options

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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!