[Tutor] how to read two files and substitute

[lina]

Hi,

For file1:

  5007  O28 CHO   173      35.300  99.430  65.810  1.00  0.0
  5008  H29 CHO   173      35.680 100.290  66.150  1.00  0.00
  5009  C1  CHO   174      59.060  12.440  58.680  1.00  0.00
  5010  C2  CHO   174      59.460  12.480  60.160  1.00  0.00
  5011  C3  CHO   174      59.590  11.120  60.830  1.00  0.00
  5012  C4  CHO   174      60.780  10.430  60.160  1.00  0.00

For file2:

5008 5010 5011

I want to get the $4(column 4) value which has  the $1 value. for
values in file2

such as the results is 173 174 174

Thanks for any suggestions,