tricky excel formula

[lemus]

Hey,

Ok heres the problem.

from an access database i have a failry large spreadsheet displaying
around 20 pivot tables.

i am after a formula to count the following:

Table 1 Table 2 (on the same worksheet)

Column A column b column d column e

smith 10 smith 5
sands 40 sands 15
toon 15 toon 8
ford 20 ford 20
clark 34 total 48
total 119



i need to calculate a percentage of column e and column b for each
person ie -

if a2 = smith then the value returned needs to be 10 (b2). that number
needs to be divided by the corresponding value from table two (5).

the pivot table will change depending upon the date range i enter into
the databse and the names will change and move around. also just
because there is a name in table one, it doenst mean that that
specific name will appear in table two.........

Any help would be greatly appreciated

thanks

Lee