Can I cross reference Excel files with each other?

Question for any Excel Guru out there.

I have two Excel files, ExcelONE and ExcelTWO. Both of thes have, or
can accept, numbers in the A column and text in the B column. Is it
possible to type a number into any A cell (e.g. A37) of ExcelONE, and
for Excel to automatically find a matching value in an A cell of
ExcelTWO, and then copy the value text from the B cell of ExcelTWO
into the B cell of ExcelONE.

For example, if I type 4158 into A37 of ExcelONE, and I know the value
4158 exists (uniquely) in an A cell of ExcelTWO, can Excel find which
row it is in (lets say it finds it in A1234, can Excel then copy the
text from B1234 into B37 of ExcelONE?