Formulas in excel

[ARVIND2013]

I'M STUCK WITH A PROBLEM. NEED HELP.

THERE ARE TWO SHEETS

SHEET 1

main cust code	linked cust code	name	balance in account A	balance in account B
123526	50456	ABC	1012	2045
123526	50455	DEF	2564	89787
123526	85456	GHI	4564	4897
123526	123526	JKL	7874	4454645

<tbody>
</tbody>

SHEET 2

main cust code	linked cust code		Asset A	Asset B
123526	50456	ABC	Car	bike
123526	50455	DEF	Bike	Car
123526	85456	GHI	TV	Computer
123526	123526	JKL	House	Car

<tbody>
</tbody>

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

Enter Main cust Code Here	....................................

<tbody>
</tbody>

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

	cust id 1	cust id 2	cust id 3	cust id 4
Main cust id	123526	85456	50455	50456
Asset owned A	house	tv	bike	car
asset owned b	car	computer	car	bike
balance in account a	7874	4564	2264	1012

<tbody>
</tbody>

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)