I am trying to save time imputing data by setting up a system that will automatically fill out an entire row of data based on a serial number typed into the first cell in that row. I am imputing ingredients into a recipe. When I enter the recipe number in A1 I would like it to automatically fill A2,A3,A4, etc with memorized amounts. For example if I type in SRP1 in Cell A1, A2 will say 8,000, A2 would be 2,300, A3 would be 500 and A4 would be 56. If I type in SRP2, it would fill the cells with different amounts that go with SRP2.