assuming i have a txt file into a dir server here is the global dim:

Global Const PATH = "\\GCD01F4500\DATI\PUBBLICA\INPS\CARTEL1.TXT"

Is possible with a vba macro ,to make a vlooup into sheet (attached) with the index in column A and retrive the result of match into column B

Note: into txt the first line is the header of record. Use this txtx file similar a MDB Access, because is shared from many user.

ziped file: http://www.mytempdir.com/644325