How do I return cell values in a specific column based on other sheet and matching reference number.

mccoy_FSI ✭✭✭✭
edited 08/04/22 in Formulas and Functions

I have a group of products all with material numbers in a database sheet. I have another sheet that I use as a database change request for for these products. When a user enters the material number on the change request sheet I want other associated values to auto-populate based on the database. Other software tools this might be called a reference column. I've looked over Index functions, this seems like it's the way to go but I can't seem to figure it out.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!