populating the record picker with a value from a spreadsheet

I've got a table or performance standards and a spreadsheet with performance measurements; the standards table is then a parent table for the measurements table.  Even though we've got the standards table key field ID attached to each of the measurements on the spreadsheet, as it stands I've got to manually select that record ID from the record picker and then enter the performance measurement for every single measurement, which ends up consuming the better part of a day.

Is there a way to use the record ID column from my spreadsheet and populate all the lookup fields automatically, rather than having to manually match the number on my spreadsheet with the number in the record picker?