Catalog # lookup

This is going to start as a simple vlookup, match, hlookup, but it has a hitch.
I have about 500 different catalog numbers but there are 3 different ranges depending on size and each range has rows marked as color and columns marked as quantity.

A large widget might be 2 colors at a quantity of 5000. I need to enter the cat# and quantity with a return of price and catalog description.

A sample spreadsheet is attached. Tables are on the first page and catalog samples on second.

Is it possible.

Thanks