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.

[AB33]

It is an array formula, not a code, so whenever you make change to the formulas, you need to do:
CRTL+ shift+enter( Hit these buttons at the end of the formula)

NOT just Enter.

If you do enter only, you will get a funny result.
I have also assumed you want to use both columns(Item no and quantity) to compare(match). If it is just an item only, I need to adjust the formula(It is actually becomes simple one)

[etaf]

you could probably use a vlookup or index match to work out the values

I see the columns M,N,O
but not sure where I would then lookup the item number to get the figures

row 12-20 on that sheet appears to have a lot of zeros for the figures
and
CS MASTER ITEM LISTING
seems to also have a lot of zeros

Vlookup would be

=VLOOKUP(B2,'CS MASTER ITEM LISTING'!$A$1:$H$9,7,FALSE)
for gross

you can then if you want muliply by the quantity

The ,7, in the above is a count of the columns from column A and A =1
so for
skids, 6
Net , 8