Drop Down List Auto Populating, wrong code?

[DrGnBld]

On my attached file, I am trying to auto-populate the cells in Z8-Z18 (QC Volumetrics Mix 1 (A)) based upon the corresponding selection from drop down list in Q7. I had thought it would be as simple and copying and pasting the code I have already used on QC Gradation Mix 1 (A) and changing it from pulling the data from the GradSpecs sheet to the BatchedList sheet. This didn't work however, and I played around a few times and was able to get the cells to populate depending on the selection, but the data wasn't in the proper cells and it looked funny, like the alignment had skewed itself somehow. SO I'm out of ideas and hopefully I'll be able to get some help here. Thank you in advance for your time.

[DrGnBld]

I figured it out. I was stuck in my own head. The only thing im not a fan of is that the formula carries over zeroes instead of leaving the cell blank, but i can easily work with that. It's far better than not having it.

[AliGW]

Try this to get rid of unwanted zeroes:

=IFERROR(1/1/your_formula),"")