My example is a column of unique text locations each with an average of how
oftern used next to each on in the ajoining column. Lets say its a column of
100 various animals. on Sheet 1
Animals Types Running Average
Tigers 4.5
Lions 2.25
Bears 3.6
Monkeys 10.4
Penguins 12.1
etc to 100

And each Zoo is presented on Sheet 2 (see below) with its columnar list of
animals and how many they have on-site. But each zoo (there are many) lists
their animals on Sheet 2 never ordered the same way as Sheet 1 compelling me
to devise a way to LOOKUP the LOCATION on Sheet 1 first, then perform the
average in sheet 1 second column. Also sheet 2 list is never 100 animals long
but a subset of sheet 1 list of animals.

Animals Types Exact Count
Tigers 4
Lions 2
Bears 3
Monkeys 10
Penguins 12
etc

So what functions to I use to continuosly update the running average for
each animal on sheet 1?

Thank you in advance - this is driving me crazy.