How do you copy cells or groups of cells from another sheet based off of another cell?

Options

How do you copy cells or groups of cells from another sheet based off of another cell. For instance, if Cell in sheet 1 = cell in sheet 2 then copy these cells? Currently, I am linking multiple cells manually and it is very inefficient.  See attached for sheet layouts.

Thanks in advance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!