Need help with IF statement formula and pulling data

[dmxcasper2]

I am trying to pull data from column I and J into column D. However I need the pulled data to me correctly inputted into Column D by "Book" and "Available" values.

The logic statement:
IF column A and B match exactly column G and H, then pull data of Column I and J into Column D.

Example:
If A3 and B3 match G2 and H2, then paste contents of I2 into D3 and J2 into D4.

Any help with this is greatly appreciated.

 

[Peter_SSs]

Any chance we could have the sample data in a format that we can copy from?
XL2BB - Excel Range to BBCode

 

[dmxcasper2]

Name	Act	B/A	AMOUNTS			ACCT NAME	ACCT #	BOOK	AVAILABLE
						TD	934567298​	$ 67,450.00	$ 987.00
TD	934567298​	BOOK				MIDLAND	548873422​	$ 8,964.00	$ 7,776.00
		AVAILABLE				MIDLAND	894112890​	$ 76,300.00	$ 34,099.00
MIDLAND	548873422​	BOOK
		AVAILABLE
CAPONE	894112890​	BOOK
		AVAILABLE

Let me know if this works.

 

[Peter_SSs]

Thanks. Try this, copied down.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Name	Act	B/A	AMOUNTS			ACCT NAME	ACCT #	BOOK	AVAILABLE
2							TD	934567298	$67,450.00	$987.00
3	TD	934567298	BOOK	67450			MIDLAND	548873422	$8,964.00	$7,776.00
4			AVAILABLE	987			MIDLAND	894112890	$76,300.00	$34,099.00
5
6	MIDLAND	548873422	BOOK	8964
7			AVAILABLE	7776
8
9	CAPONE	894112890	BOOK	#N/A
10			AVAILABLE	#N/A
Sheet3

Cell Formulas
Range	Formula
D3:D10	D3	=IF(C3="","",INDEX(I$2:J$4,MATCH(A2&A3&"|"&B2&B3,INDEX(G$2:G$4&"|"&H$2:H$4,0),0),MATCH(C3,I$1:J$1,0)))

 

[dmxcasper2]

Thank you very much!!!

This worked as intended.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.