Text data with assigned IDs-Need two spreadsheets to "Talk"

[dawsonsoo]

Here's my situation.

In workbook A, I have 2,000 records, cleaned/de-duped

I have columns A, B, and C:
Blank|Truman school, San Diego |1234
Blank|Truman school, San francisco|1235
Blank|Truman school, Atlanta|1236
Blank|Nice school, Georgia|1237
Blank|Nice school, Raleigh|1238

I used =MAX($B$1:B1)+IF(COUNTIF($A$2:A2,A2)=1,1,0) copied down and deduped in order to get my results in Workbook1

In Workbook B, I have about 6,000 records and they look like this in columns A, B, C
Laura|Truman school, San Diego | need id to match from workbook 1 for column C
Trevor|Truman school, San Diego|need id to match from workbook 1 for column C
Sandy|Truman school, San Diego|need id to match from workbook 1 for column C
Kate|Truman school, San francisco|need id to match from workbook 1 for column C
Rudy|Truman school, San francisco|need id to match from workbook 1 for column C
Sean|Truman school, Atlanta|need id to match from workbook 1 for column C
Mark|Nice school, Raleigh|need id to match from workbook 1 for column C
Tom|Nice school, Georgia|need id to match from workbook 1 for column C

Could you please help? Many thanks in advance.