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

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.

I was getting lost in trying to click cells between sheets hoping Excel would correctly generate my formula. It took me a while but after trying to understand what the formula is actually supposed to look like, I typed it out and it's working. This is what I came up with:

Formula:

Please Login or Register  to view this content.

Thanks for the tip, I will try to reference another workbook so that I don't have to keep pasting the sheet into every inventory file.

Now I'm in pain. I had it working perfectly, but tried to link to another workbook and deleted the reference sheet. I typed out the path and I had misspelled it, Excel gave me an "Open" dialog and I double clicked on the sheet I wanted.

The result was correct and I thought everything was working. I dragged the formula down the column and the results updated. Almost magical. Then when I copied the formula into the next column I got REF! errors everywhere and my once working formula has REF! instead of the workbook/sheet path.

What the heck did I do?

---------------------------------------------------------------------------------

EDIT: I don't know what happened with the copy and pasting problem but I re-wrote the formula and put "$" in front of the letters that shouldn't change.

This is what worked for me (note: I renamed files and sheets to make typing the formula easier)

Formula:

Please Login or Register  to view this content.

Thanks for the tip on referencing another workbook. Now I only need to worry about maintaining one table with the dimensions.

Question on that, do I need to keep the workbooks in the same folder at all times?