Lookup or Match and copy Urgent

[Guest]

Hi all

I have a data in sheet1 and sheet2 has data in colA and ColB.
If the data in ColA and ColB of sheet2 matches with data in ColA and ColB of
sheet1. Then the data in sheet1 from colC to end needs to be copied in Sheet1
where the match was found.

I am not able to to this meeting two criterias


Any help will be greatly appreciated

Thanx
Sarita






Source data in sheet1
A B C D E F H
30 34
30 34
32 36
33 36

Source data in sheet2
A B C D E F G H

30 34
32 36
33 36

 

[Frank Kabel]

Hi
try the array formula (entered with CTRL+SHIFT+ENTER)
=INDEX('sheet1'!C1:C100,MATCH(1,('sheet1'!A1:A100=A1)*('sheet1'!B1:B100
=B1),0))