Shell Programming and Scripting

I have a lookup file in unix say /data/lkp.dat (First line is header and space delimited) and the content is shown below.
Another file which contains the job_name and rec_count lets say /data/data_file.dat(no header pipe delimited file).
Now i want to do a lookup on job_name and my output should be 4 files
TYPE1_File1
TYPE2_File2
TYPE3_File3
TYPE4_File4

depending on TYPE field.The output should be a | delimited file
and the layout will be

FILE_NAME
REC_COUNT

Code:

JOB_NAME	FILE_NAME	TYPE
A_1	HGG.dat	TYPE1
B_1	SDF.dat	TYPE1
C_1	FHH.dat	TYPE1
D_1	UUU.dat	TYPE1
E_1	UUKK.dat	TYPE1
A_2	HGG.dat	TYPE2
B_2	SDF.dat	TYPE2
C_2	FHH.dat	TYPE2
D_2	UUU.dat	TYPE2
E_2	UUKK.dat	TYPE2
A_3	HGG.dat	TYPE3
B_3	SDF.dat	TYPE3
C_3	FHH.dat	TYPE3
D_3	UUU.dat	TYPE3
E_3	UUKK.dat	TYPE3
A_4	HGG.dat	TYPE4
B_4	SDF.dat	TYPE4
C_4	FHH.dat	TYPE4
D_4	UUU.dat	TYPE4
E_4	UUKK.dat	TYPE4

Every day the file name will contain one extention of system date in YYYYMMDD format like

Code:

HGG_20090401.dat

what have you done so far?

If i can get the code to do a lookup with job_name as key(the data file has no headers and first line of lookup file is a header) rest all things can be done.it would be great if you can help with the lookup code