Extract Data

[Gusher]

In sheet 1 In col A I have a list of banks by name.

In cols B to Z I have Performance Data relating to each bank. In row 1 I have the name of the performance data. So for example in cell B1 we have
"Total Assets".

In Sheet 2 cell B1 I have the name of a bank from col A sheet 1. In Sheet 2 cell B2 I have the one of the performance data labels from Sheet 1 row one, so for example it could be "Total Assets".

I need a formula in Sheet 2 that will find the combination of the bank and performance data and extract it from sheet 1.

hope that makes sense

 

[AhoyNC]

Something like this?
Sheet 2

Book1
	A	B	C
1		Bank B
2		Loans	55,000
Sheet2

Cell Formulas
Range	Formula
C2	C2	=INDEX(Sheet1!$B$2:$D$4,MATCH($B$1,Sheet1!$A$2:$A$4,0),MATCH($B$2,Sheet1!$B$1:$D$1,0))

Sheet 1

Book1
	A	B	C	D
1	Banks	Total Assets	Loans	Deposits
2	Bank A	150,000,000	60,000	1,250,000
3	Bank B	175,500,000	55,000	2,000,000
4	Bank c	257,500,000	100,000	2,800,000
Sheet1

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ExcelNewbie2020]

Something like this?
Sheet 2

Book1
	A	B	C
1		Bank B
2		Loans	55,000
Sheet2

Cell Formulas
Range	Formula
C2	C2	=INDEX(Sheet1!$B$2:$D$4,MATCH($B$1,Sheet1!$A$2:$A$4,0),MATCH($B$2,Sheet1!$B$1:$D$1,0))

Sheet 1

Book1
	A	B	C	D
1	Banks	Total Assets	Loans	Deposits
2	Bank A	150,000,000	60,000	1,250,000
3	Bank B	175,500,000	55,000	2,000,000
4	Bank c	257,500,000	100,000	2,800,000
Sheet1

it seems you figured it out?..what is wrong with your current formula?

 

[Peter_SSs]

it seems you figured it out?..what is wrong with your current formula?

Have you confused AhoyNC with Gusher?

 

[ExcelNewbie2020]

Have you confused AhoyNC with Gusher?

oopps.. my bad..i thought they are the same person..

 

[Gusher]

In sheet 1 In col A I have a list of banks by name.

In cols B to Z I have Performance Data relating to each bank. In row 1 I have the name of the performance data. So for example in cell B1 we have
"Total Assets".

In Sheet 2 cell B1 I have the name of a bank from col A sheet 1. In Sheet 2 cell B2 I have the one of the performance data labels from Sheet 1 row one, so for example it could be "Total Assets".

I need a formula in Sheet 2 that will find the combination of the bank and performance data and extract it from sheet 1.

hope that makes sense

Many thanks AhoyNC that worked

 

[Peter_SSs]

Many thanks AhoyNC that worked

Good news!

Could we have that profile update now so we know what functions and features you have available next time you ask a question?