Two sheets, Street, City copy ID

[Beginner778]

Hi,

I have two sheets:

Sheet 1 (1K rows)

Street (A column)
City (B column)

Sheet 2 (2K rows)
Street (A column)
City (B column)
ID (C column)

Problem: If the street and city match in the sheets (1,2), copy the ID to the C column in Sheet 1

I tried modifying the code with bold text

Thank you very much for help

 

[Toadstool]

But column C on Sheet1 is calculated so will be empty unless columns A and B match.

 

[Beginner778]

Sorry Zip its not good but phone so:

Sheet2:

Sheet1:

Function to D column if phone number Sheet1 row E=Sheet2 rowD copy ID to column D

 

[Toadstool]

Beginner778-2.xlsx
	A	B	C	D
1	Street	City	Id	Telephone No
2	Main	Miami	ABC	1
3	1st	Miami	MNB	2
4	Elm	Brice	XYZ
5	Oak	Belmont	PGT	4
6	AA	BB	AWS	123
Sheet2

Beginner778-2.xlsx
	A	B	C	D	E
1	Street	City	Id by City, Street	Id by Phone	Phone no
2	Elm	Miami
3	Elm	Brice	XYZ		3
4	Main	Miami	ABC	ABC	1
5	1st	New York
6	Oak	Portland
7	Oak	Belmont	PGT	PGT	4
8	CC	DD		AWS	123
Sheet1

Cell Formulas
Range	Formula
C2:C8	C2	=IF(A2="","",IFERROR(INDEX(Sheet2!$C$2:$C$1200,AGGREGATE(15,6,ROW(Sheet2!$A$2:$A$1200)-ROW(Sheet2!$A$1)/((Sheet2!$A$2:$A$1200=A2)*(Sheet2!$B$2:$B$1200=B2)),1)),""))
D2:D8	D2	=IF(ISNA(MATCH(E2,Sheet2!$D$2:$D$1200,0)),"",INDEX(Sheet2!$C$2:$C$1200,MATCH(E2,Sheet2!$D$2:$D$1200,0)))