I'm making a new pricelist for my kitchen manufacturing business, and I need to access multiple lookup table containing heights, wdths and prices for various materials, tables are based on lacquer, timber, veneer, vinyl, etc, etc

The basic formula I'm using at the minute is;(which will access only 1 table)

=INDEX(xalifrost,MATCH(L1071,yalifrost,1)+(LOOKUP(L1071,yalifrost) < L1071),MATCH(M1071,zalifrost,1)+(LOOKUP(M1071,zalifrost) < M1071))

were xalifrost = the prices, yalifrost = the heights of the doors, zalifrost = the widths of the doors (in this case they are aluminium glass doors)

What I want to do is to acess multiple (at the minute it is 20), lookup tables,

Melamine Square Edge
Melamine ABS Edge
Melamine Rolled Edge
Laminated Square Edge
Createc Square Edge
Vinyl Texture
Vinyl Woodgrain
Vinyl Matt/Satin
Vinyl Gloss
Vinyl Metallic
Veneer American Oak
Veneer Birdseye Maple
Timber Tasi Oak
Timber Jarrah
Timber American Oak
Lacquered Texture
Lacquered Laminex
Lacquered Custom Satin
Lacquered Custom Gloss
Lacquered Custom Metallic

and access the pricing using the heights and widths,

any help will be appreciated.

thx