How do I return cell values in a specific column based on other sheet and matching reference number.
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
Check out the Formula Handbook template!