Find Row with 2 columns matched value on one worksheet from Range of 3 columns & 2 combination different worksheet

[jinxz72]

Yikes! It sounds horrible but here goes... Using Excel 2010:

Worksheet 1 - Need to find C (Status) from Worksheet 2

	A	B	C
1	Business Name	Address	Status
2	Joe's Bar & Grill	1111 Main St	?
3	Ace Shop	4186 Power Inn Rd	?
4	Thomas Train	1717 Rail way	?

<TBODY>
</TBODY>

Worksheet 2 - Range with 2 Address options & Status

	A	B	C	D
1	Patty's Paints	1111 Main St	PO Box 888	SB
2	Ace Shop	PO Box 1000	4186 Power In Rd	MB
3	Thomas Train	1717 Rail way	1717 Rail way	SB
4	Links Swords	45 Princess Way	9090 Zelda Rd, Lvl 1	SB

<TBODY>
</TBODY>

Challenge:
On worksheet 1, return Column D from Worksheet 2, when Column A & B (Business name & Address) from worksheet 1 match either a combination of Column A & B or Column A & C on worksheet 2, or return N/A in cases of no match.

I can't seem to get the Index & Match to work, and I am not sure if IFThen or SUMProduct is more appropriate.

Any suggestions?

Thanks!!