I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
Animal_____Horse__Wolf__Bear___Tiger
Sheet2
Orange_____ 3
Apple_______6
Tiger_______ 1
Banana_____ 7
Horse______ 10
So what I'm trying to do is sum the quantities of the different kinds of Fruits or Animals in Sheet2. Therefore, whenever I use this formula for a specific row in Sheet1, I would have the total number of fruits in Sheet2 (16) or the total number of animals (11).
Thanks in advance for the help!
P.S. Sorry if the example looks terrible! :(
sumifs