+ Reply to Thread
Results 1 to 2 of 2

multiple lookup tables

  1. #1
    Registered User
    Join Date
    03-30-2008
    Posts
    9

    multiple lookup tables

    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

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: multiple lookup tables

    Without a sample file I must confess it's hard to visualise what you're trying to do ... if you're saying you want xalifrost/yalifrost/zalifrost to be variable (and you have 20 variations thereof) you will most likely need to use INDIRECT Function (Volatile).

    For more assistance I think a sample file with dummy data would be required - detailing expected results etc...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1