VBA Excel To Match 2 columns on sheet A with 2 columns on sheet B and return value

[itonic]

I need a VBA Excel Script To Compare columns A & B in Worksheet One Against A & B In worksheet Two If A Match Is Found Return column C from Worksheet One.
Ive can do this in excel using a formula but it is speed im after so hopefully doing via VBA would be quicker and id prefer the final output of the table to only contain values instead of formulas.
Ive done a lot of digging but cant find this piticular requirement.
Any help on this is gratefully appreciated.
This is th excel formula im currently using
{=IFERROR(INDEX(SQLData!D:D,MATCH(1,(SQLData!A:A=A2)*(SQLData!B:B=B2),0)),"0")}

I have already asked this question on SO VBA Excel To Match 2 columns on A with 2 columns on B and return value - Stack Overflow however ive had no replies for a few days.
If this gets answered on either I will be sure to close and ref the answer.

 

[itonic]

Hi Stridhan

Superb bit of scripting, I cant thank you enough for taking the time out of your day to construct this and add the comments

Legend!!

 

[Stridhan]

I'm glad I could help ��