Equations
 

I have two rows of 10 tables on a worksheet. The first row
of each table is the name of the table(text). I have
several colums of data(numbers) and down the right most
column I have the name of another table. I would like to
create an equation that would take a number from the first
table, then go to the right most column of the first
table, get the table name, then go to the second table,
add a number from the second table to the number from the
first table, and then divide everything by 2.

I would appreciate it if someone could show me how to do
this.

Thanks!