The name entered into an input cell will essentially select different lookup ranges, A2:D5 or A2:H5 or A2:L5, and then some sort of lookup will find the hardcoded variable of animal type and and animal age, and give the listed quantity. The actual data table has 30 names (3 bins each) arranged in this manner, so IF statement won't work.

2v9ap09.jpg

(Moderator: Is it ok post the same question in another forum?)