your list of Zip codes is in a text format, and your data fields are in numaric format, so what you need to do is convert the list to numbers, i did this using =INT(A1) in column C then copying those values back into A

then i modified the vlookup as follows and it is now working

=VLOOKUP(INT(LEFT(F2,5)),Sheet2!A:B,2,0)