You want to look up a value in the second file based on a key in the first file.

For the look up table a good bet would be to load the second file into DBM::Deep.

You would then simply read a line at a time from the first file looking up the data you need in the db as you go. hth