Filling Data depending on Zip Code

I am working with monsterous excel sheets (named Data) and need to a column that is governed by the ZIP. I have a sheet named Source in my excel folder with all the matching information next to the excel sheet. The column my zip codes in Data starts on J6 to J290 and the zip codes in Source are from A2 to A2671. The information I am trying to pull from Source to Data are names and branches located in Source from B2:E2671.

What function will auto fill the columns with the correct information. If it can only be done by putting a function into each column, that is not a problem

I would try VLOOKUP.