Formulas in excel

[ARVIND2013]

I'M STUCK WITH A PROBLEM. NEED HELP.

THERE ARE TWO SHEETS

SHEET 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]main cust code[/TD]
[TD]linked cust code[/TD]
[TD]name[/TD]
[TD]balance in account A[/TD]
[TD]balance in account B[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]50456[/TD]
[TD]ABC[/TD]
[TD]1012[/TD]
[TD]2045[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]50455[/TD]
[TD]DEF[/TD]
[TD]2564[/TD]
[TD]89787[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]85456[/TD]
[TD]GHI[/TD]
[TD]4564[/TD]
[TD]4897[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]123526[/TD]
[TD]JKL[/TD]
[TD]7874[/TD]
[TD]4454645[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


SHEET 2

[TABLE="width: 500"]
<tbody>[TR]
[TD]main cust code[/TD]
[TD]linked cust code[/TD]
[TD][/TD]
[TD] Asset A[/TD]
[TD]Asset B[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]50456[/TD]
[TD]ABC[/TD]
[TD]Car[/TD]
[TD]bike[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]50455[/TD]
[TD]DEF[/TD]
[TD]Bike[/TD]
[TD]Car[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]85456[/TD]
[TD]GHI[/TD]
[TD]TV[/TD]
[TD]Computer[/TD]
[/TR]
[TR]
[TD]123526[/TD]
[TD]123526[/TD]
[TD]JKL[/TD]
[TD]House[/TD]
[TD]Car[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want to create a main page where result reqd is as below .

[TABLE="width: 500"]
<tbody>[TR]
[TD]Enter Main cust Code Here[/TD]
[TD]....................................[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Using formula information should be picked from both the sheets. what formula is to be applied please help.

[TABLE="width: 500"]
<tbody>[TR]
[TD] [/TD]
[TD]cust id 1[/TD]
[TD]cust id 2[/TD]
[TD]cust id 3[/TD]
[TD]cust id 4[/TD]
[/TR]
[TR]
[TD]Main cust id[/TD]
[TD]123526 [/TD]
[TD]85456[/TD]
[TD]50455[/TD]
[TD]50456[/TD]
[/TR]
[TR]
[TD]Asset owned A[/TD]
[TD]house[/TD]
[TD]tv[/TD]
[TD]bike[/TD]
[TD]car [/TD]
[/TR]
[TR]
[TD]asset owned b[/TD]
[TD]car[/TD]
[TD]computer[/TD]
[TD]car[/TD]
[TD]bike[/TD]
[/TR]
[TR]
[TD]balance in account a[/TD]
[TD]7874[/TD]
[TD]4564[/TD]
[TD]2264[/TD]
[TD]1012[/TD]
[/TR]
</tbody>[/TABLE]

Please don't advise me to use pivot. what other formulas can be used.


Regards
Arvind

 

[Jon von der Heyden]

bump (on behalf of Arvind)