Merging two Data Sets

[smarcoulides]

The first set is 8045 rows with headers: Campus|District. The second set is 1040 rows with headers: District|City.

I need to add the corresponding City to the first data set to end up with: Campus|District|City.

I'm not very familiar with VBA or for loops but I think that's the route I need to go.

Thanks.

 

[Special-K99]

VLOOKUP perhaps

in Sheet1!C1
=VLOOKUP(B1,Sheet2!A$1:B$1040,2,0)
and copy down

where
Sheet 1
Column A Campus
Column B District

Sheet 2
Column A District
Column B City

 

[smarcoulides]

Perfect, I have only heard of Vlookup. Thanks for the quick response.