$$ Starting in column H $$Gallons of Water $($per shirt$),$ use the VLOOKUP function to start with the value from the $$PRODUCT$$ column as an input and retrieve the appropriate related value from the $$Gallons$$ column in the table at the top of the $$Assumptions$$ worksheet.

If done correctly, this $($per shirt$)$ number of gallons should appear in the $$Gallons of Water $($per shirt$)$ table for every batch $($see screenshot below for the first few rows$).($HINT: $$Category$$ in column G also uses the VLOOKUP function$)$

$$ Next, in column I, input a formula in the cell that multiplies the Gallons of Water $($per shirt$)$ measure by the number of shirts produced in the batch $($BATCH SIZE$)$ to calculate the total number of gallons required to produce the fabric in each batch of t$-$shirts. $($See screenshot below$)$