Please Help. Need to Replace Words with Numbers from the Other Sheet

[Louie Zabala]

Hello guys. Good day. I needed some help.
I have two spreadsheets source (sheet 1:nodes) and destination (sheet 2:edges).

I need to have the entries in sheet 2 be replaced with numbers based on their order in sheet 1.

Ex.
This is what the first three items in colums A and B in sheet 2

TYPE OF USER	TITLE
APSP	A neglected dimension in service-learning pedagogy : developing projects from the perspective of rural community stakeholders
ASF	An ambivalent state : the crossover of corruption and violence in the Philippines.
ASF	Assessment of the DLSU undergraduate mechanical engineering on-the-job training program

I want them to appear like

TYPE OF USER TITLE

1 7
2 8
2 9

Please help. Attached are the files. Thank you.

 

[p45cal]

Have both workbooks open.
In Edges.xlsx, Sheet1, cell C2, this formula:

=INDEX([Nodes.xlsx]Sheet1!$A$2:$A$277,MATCH(A2,[Nodes.xlsx]Sheet1!$B$2:$B$277,0))

Copy across 1 cell to the right, then copy both down as far as necessary.
Select all the formulae cells, then copy, paste-values in situ, to replace the formulae with their values. Then delete columns A and B.
Add headers.