Need help using LOOKUP (or INDEX-MATCH) between sheets

[frankunited]

I have a sheet that lists most of the common tire sizes that we sell along with the tire dimensions for shipping. I am sent a sheet that has a list of inventory that is in stock. Is there a way to create a column that will match the tire size and fill in the dimensions for each row? I was planning on copying and pasting each one at a time, but figured there must be some way to have excel match the size and pull the data.

Thank you.

EDIT: I have updated my post after reading up a little on the LOOKUP function. It looks like I just need to adjust the formula a bit for each column (i.e. length, width, height). Where I am still lost is referencing the table from another sheet. I have copied the sheet so that I have everything in one workbook. I have a feeling I'm on the right track.