Find match using composite search in macro

I have a requirement where I have to search for a match taking composite column values defined in another worksheet.

Say I have worksheet named "sheet1"

[TABLE="class: outer_border, width: 500"]

[tr]

[td]

Col A

[/td]

[td]

Col B

[/td]

[td]

Col C

[/td]

[td]

Col D

[/td]

[td]

Col E

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

[TABLE="width: 65"]

[tr]

[TD="width: 65"]New

[/tr][/td][tr]

[/tr]

[/TABLE]
[/TD]

[td]

1

[/td]

[td]

[TABLE="width: 65"]

[tr]

[TD="width: 65"]W

[/tr][/td][tr]

[/tr]

[/TABLE]
[/TD]

[td][/td]

[/tr]

[tr]

[td]

[TABLE="width: 65"]

[tr]

[TD="width: 65"]B

[/tr][/td][tr]

[/tr]

[/TABLE]
[/TD]

[td]

Old

[/td]

[td]

2

[/td]

[td]

X

[/td]

[td][/td]

[/tr]

[tr]

[td]

C

[/td]

[td]

New

[/td]

[td]

3

[/td]

[td]

Y

[/td]

[td][/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

Old

[/td]

[td]

6

[/td]

[td]

P

[/td]

[td][/td]

[/tr]

[/TABLE]

In "Sheet2" I have the composite mappings

[TABLE="width: 500"]

[tr]

[td]

Col A

[/td]

[td]

Col B

[/td]

[td]

Replacement Value

[/td]

[/tr]

[tr]

[td]

B

[/td]

[td]

X

[/td]

[td]

Value1

[/td]

[/tr]

[tr]

[td]

A

[/td]

[td]

P

[/td]

[td]

value2

[/td]

[/tr]

[/TABLE]

Result what I wanted to have is

[ATTACH=CONFIG]69828[/ATTACH]

Can some one help me out on this. I'm new to macro any just wondering is that possible or not ? Any feedback/ Suggestions would be very much appreciated !
Thanks for your time.

Re: Find match using composite search in macro

Thanks @sktneer , It worked. Appreciated your help !