Help with formula to pull over values between workbooks

[JRAMZ88]

Hi everyone, Happy Saturday!

Reaching out for help with building a formula that pulls in a value based on two criteria.

In a nutshell, we have two workbooks... workbook A is the source data, and workbook B is the summary.
I'm looking for a formula that will pull in the corresponding values into the correct cells based on Acct #1 and Period 1...
So in the example below, the $500 in cell D3 for Acct #1 and Period 1, needs to end up in cell K3 of workbook 2.

Going to paste my xl2bb mini sheet below.. any help would be greatly appreciated!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Workbook A							Workbook B
2		Period		Acct #1	Acct #2	Acct #3					P1	P2	P3
3		P1		$ 500	$ 120	$ 200			Acct #1
4
5
6
7
8
9
10
11
Sheet1

 

[SanjayGMusafir]

Check this and revert -

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Workbook A							Workbook B
2		Period		Acct #1	Acct #2	Acct #3					P1	P2	P3
3		P1		500	120	200			Acct #1		500
4									Acct #2		120
5									Acct #3		200
6
Sheet1

Cell Formulas
Range	Formula
K3:K5	K3	=INDEX($D$3:$F$7,MATCH(K$2,$B$3:$B$7,0),MATCH($I3,$D$2:$F$2,0))

 

[JRAMZ88]

Check this and revert -

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Workbook A							Workbook B
2		Period		Acct #1	Acct #2	Acct #3					P1	P2	P3
3		P1		500	120	200			Acct #1		500
4									Acct #2		120
5									Acct #3		200
6
Sheet1

Cell Formulas
Range	Formula
K3:K5	K3	=INDEX($D$3:$F$7,MATCH(K$2,$B$3:$B$7,0),MATCH($I3,$D$2:$F$2,0))

Good morning! Yes, thank you so much - this helps alot and works perfectly.

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.