I want to pull data from one Excel file to another. This a formulation sheet that I want the date pulled to. Once a tradename is recognized, I would like for the INCI, supplier, and function to be automatically populated. The name of this file is Formulation Template Draft 2020.
Formulation Sheet.png
I want it pulling from this file, called 2020 Ingredient List With Contacts.
Master Formulation Sheet.png
I know very little about Excel. This was successfully done by an employee before me, but it fell apart when used on different computers and when the master list was edited. I don't know what formula was used or how to do this. I tried looking it up, but I cant seem to get much further than messing around with the formulas that I don't fully understand and I have not ventured into VBA, which is where I will likely land. Thank you so much.
Bookmarks