Macro for copying data from one column in sheet 2 based on two criterias in sheet 1

Hi.

I've been struggeling for quite som time on how to perform this task with the help of macros.
I have a workbook with basicly two sheets.
Sheet1 is the main sheet, but I'm missing som data in the column "IB". This data is in another sheet. I would like to create a macro that checks the cokumns company and accountnumber i sheet1 against the same information in sheet2, if correct then copy the corresponding IB cell and paste into sheet1.

I hope someone can help me with this?

Best regards!

You could do this with a formula.

Put this in D2 on Mainsheet and copy down column D

=INDEX(Sheet2!$C$1:$C$28,MATCH(1,(A2=Sheet2!$A$1:$A$28)*(C2=Sheet2!$B$1:$B$28),0))

This is an array formula. Confirm the formula with Ctrl+Shift+Enter

Hey, that worked out brilliantly! Thank you so much for your help
Have a nice day!

Best regards

Hi,

Please have a review of this attached file and let me know is it meet ur requirement or not.

that Array formula make whole active workbook performance very very slow.

I hv updated the formula.
=IFERROR(VLOOKUP(CONCATENATE($A2&" > "&$C2),Sheet2!$A:$D,4,0),"")

Thanks- Naveed