Google Sheets, Vlookup

I'm trying to fill in a sheet with information from 4 columns in another one, I am using Vlookup, I'm using serial numbers to match the info. The problem is that I have info submitted in different times for different columns using the same serial number, so vlookup only returns info from the first submission and ignores the most recent ones, any ideas?

This is an example of the sheet I'm using, I'm trying to match info from Data to Sheet 1. Vlookup returns info from columns 1 and 4 but ignores info in 2 and 3.

http://ift.tt/2h6g1nF

I'm using the formula: =ARRAYFORMULA(IF.ERROR(VLOOKUP($A$10:$A;{$G$10:$K};2;FALSE)))

Help!!