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
[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Business Name
[/TD]
[TD]Address
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Joe's Bar & Grill
[/TD]
[TD]1111 Main St
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Ace Shop
[/TD]
[TD]4186 Power Inn Rd
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Thomas Train
[/TD]
[TD]1717 Rail way
[/TD]
[TD]?
[/TD]
[/TR]
</TBODY>[/TABLE]








Worksheet 2 - Range with 2 Address options & Status [TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Patty's Paints
[/TD]
[TD]1111 Main St
[/TD]
[TD]PO Box 888
[/TD]
[TD]SB
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Ace Shop
[/TD]
[TD]PO Box 1000
[/TD]
[TD]4186 Power In Rd
[/TD]
[TD]MB
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Thomas Train
[/TD]
[TD]1717 Rail way
[/TD]
[TD]1717 Rail way
[/TD]
[TD]SB
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Links Swords
[/TD]
[TD]45 Princess Way
[/TD]
[TD]9090 Zelda Rd, Lvl 1
[/TD]
[TD]SB
[/TD]
[/TR]
</TBODY>[/TABLE]
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!!