plugging data from one workbook into another

[KamiAlabama]

I am working with 2workbooks and need to enter values from one into the other's corresponding data. I am rusty on creating formulas; it has been a decade since I worked with them regularly. The sheet on one workbook is over 600 lines so it is a lot of data in text form (names of colleges). If AB on [Proposed Data.xls] is the same as C on [consolidated.xls] then insert cell value from AD on [Proposed Data.xls] into cell BS on [consolidated.xls]. It is just a long spreadsheet and I simply want to plug the information into Consolidated. The data I am now plugging are percentages. I did a lot of copying & pasting from one workbook to the other to get the text names input, but I know this can be done and am just rusty right now. Can you help?