Populate Column

I have a sheet named GROCERYSTORE and a column named PRODUCE. 

I have another sheet named PANTRY and a column named VEGGIES. 

I want to reference column PRODUCE so those values are pulled into my VEGGIES column. If I later add a entry to the PRODUCE column, I want it to automatically show in my VEGGIES column.

Thank you in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!