VBA Vlookup function returns wrong values

Thanks a lot michson. I really appreciate your help. I tried using it in place of my current code. However, it returns with #N/A. the formula in the cell (1,11) is

=VLOOKUP(B4,$A$16:$I$55, 9, FALSE)

It seems like it is not referring to the source file. Maybe I need to add it in? or do you mind if I send you the two excel files so you can see if there are some fundamental mistakes I made on the table_array selection? Thank you again.