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

Global Const PATH = "\\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 from the text file, into column B

Note: into txt the first line is the header of record.

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