# i need a function for all off the table 2

#### mgm90210M

##### Board Regular
 a1 b1 c1 d1 e1 4 3 6 7 9 6 6 4 8 3 5 8 2 8 1

<tbody>
</tbody>

a22b22c22d22
=corral(column a in table one with column a with table tow)=corral(column a in table one with column d with table tow)
=corral(column b in table one with column c with table tow)
 =corral(column a in table one with column d with table tow)

<tbody>
</tbody>
=corral(column a in table one with column d with table tow)

<tbody>
</tbody>

i need a function for all off the table 2
that fill the table 2 with corlation with table 1
like i show in the sample

thanks

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
anybody please can help me to solve this problem ?

a22b22c22d22
=corral(column a in table one with column a with table tow)
 =corral(column b in table tow with column a with table one)

<tbody>
</tbody>
=corral(column c in table tow with column a with table one)
=corral(column a in table one with column d with table tow)
=corral(column b in table one with column b with table tow)
 =corral(column b in table one with column b with table tow)

<tbody>
</tbody>
 =corral(column b in table one with column c with table tow)

<tbody>
</tbody>
 =corral(column a in table one with column d with table tow)

<tbody>
</tbody>

 =corral(column b in table one with column d with table tow)

<tbody>
</tbody>
=corral(column a in table one with column d with table tow)

<tbody>
</tbody>

Replies
3
Views
173
Replies
0
Views
87
Replies
1
Views
73
Replies
7
Views
160
Replies
1
Views
78

1,206,826
Messages
6,075,096
Members
446,120
Latest member
Heremion

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back