Conditional Formulas - How do I make quantity of a cell change the value of other cells?

Hi

Q11: =IFERROR(VLOOKUP(P11,P$26:Q$37,2,FALSE),"")
Copy down to Q15, then copy Q11:Q15 and put into S11, U11 etc

Is that what you want?

rylo

Exactly the formula I was looking for! Thanks for all your help! And for not making me feel like the idiot I am when it comes to Excel. You're the best!