How to input data from a text file?

I'm trying to import a list such as this:

3D OIL LIMIT,TDO,Energy
3D RESOURCES,DDD,Materi
3Q HOLDINGS ,TQH,Softwa
4C SECURITY ,FCS,Techno
A-CAP RESOUR,ACB,Materi
A.B.C. LEARN,ABS,Consum
A1 MINERALS ,AAM,Materi
AAQ HOLDINGS,AAQ,Food B
etc...

from a text file, and do a search on a range
of three-letter codes such as this:

AAH
AAM
AAR
AAX
ABY
ACL
ACR
ACS
ADI
ADN
ADY
etc...

If the three letter code (in the second field) matches one in the range,
I'd like to input the company name into the cell beside it. Would anyone
be able to furnish some code which does this or something similar please?
Thanks for any help!