Have Gross/Net weights auto populate

[rhale27]

Hello,
Have Workbook with 2 sheets. Sheet 2 contains the item numbers and quantities (these are downloaded from a report) and Sheet 1 allows entry of a quantity(Column B) & will then provide the gross weight(column G) & net weight(column H) and Skid count(column F) based on the item number (Column A) and the quantity.
Is there a way to have excel 'read' the item number and quantity on sheet 2 and plug the quantity into the correct spot for that item number on sheet 1 and return the results in the 'gross weight', 'net weight' and 'skid' fields on sheet 2?
Please see attached.

To sum up - my goal (dream) is to have the columns M, N and O on sheet 2 auto populate.
I freely admit to being a natural born idiot so the clearer the example, the better.

ANY help would be so incredibly appreciated - honestly been struggling with this for ten evers.