multiple criteria with two or more

[hgchas]

hello I am working on adjusting this code I have had help before and it worked! thinking I could try again. my objective would be to bring phone number and city from sheet2 to sheet 1. the code that helped me out before was the one below and am wanting to duplicate it but get runtime errors.

[Trebor76]

Hi hgchas,

Here's an alternative:

Please Login or Register  to view this content.

Regards,

Robert

[hgchas]

This worked on my end. Thank you for your help!

I only made a small adjustment:
.Range("B2:B" & lngLastRow_Sht1).FormulaArray = "=INDEX('" & wsSht2.Name & "'!D2:D" & lngLastRow_Sht2 & ",MATCH(A2,'" & wsSht2.Name & "'!A2:A" & lngLastRow_Sht2 & ",0),MATCH(C2,'" & wsSht2.Name & "'!B2:B" & lngLastRow_Sht2 & ",0))"