autopopulate from another excel file in cloud location?

Hi all - is it possible to auto populate a row of data from a search in another excel file. Both files are in Box, so a secured cloud location. Basically some sort of IF statement where if a specific client shows up in Column J, then copy J1-15 to this row, type equation (hope that makes sense!).
Thanks excel pros!!

Alexis

Any help on this one? Maybe a Vlookup function?