Results 1 to 8 of 8

Lookup table with exceptions?

Threaded View

gavster Lookup table with exceptions? 04-07-2009, 06:01 AM
martindwilson Re: Lookup table with... 04-07-2009, 06:10 AM
gavster Re: Lookup table with... 04-07-2009, 06:21 AM
martindwilson Re: Lookup table with... 04-07-2009, 06:32 AM
gavster Re: Lookup table with... 04-07-2009, 06:45 AM
DonkeyOte Re: Lookup table with... 04-07-2009, 07:12 AM
DonkeyOte Re: Lookup table with... 04-07-2009, 06:13 AM
gavster Re: Lookup table with... 04-07-2009, 08:32 AM
  1. #1
    Registered User
    Join Date
    02-24-2007
    Posts
    84

    Wink Lookup table with exceptions?

    I'm currently using a lookup table to determine programs to run on a machine, however I have 3 exceptions to this and can not get my code to work.

    Currently the code looks at column D for the type, then column F for the thickness of material. It then calculates the etch time required using the rate (all shown as 1 currently) on the cal_sheet and then rounds this up to a whole number. This is then compared to a second table where the program details are listed against etch times.

    It will make sense when you look at the attached workbook and read the code, honest!

    Currently using the following code:
    =IF(F5="","",LOOKUP(ROUNDUP((F5/(LOOKUP(D5,'Calc Sheet'!F:F,'Calc Sheet'!H:H))),0),'Calc Sheet'!$K$1:$K$44,'Calc Sheet'!$J$1:$J$44))
    This works for everything except my exceptions.

    My proposed new version is:
    =IF(F6="","",(if(D6="A","A program",(if(and(D6="B",F6<16,"B Thin",(if(and(D6="B",F6>16,"B Thick",LOOKUP(ROUNDUP((F6/(LOOKUP(D6,'Calc Sheet'!F:F,'Calc Sheet'!H:H))),0),'Calc Sheet'!$K$1:$K$44,'Calc Sheet'!$J$1:$J$44))))))))))
    But I keep getting an error, highlighting the second LOOKUP.

    Can anyone help please, it probably a simple problem, I just cant see it.

    Thanks,
    Gavin.
    Attached Files Attached Files
    Last edited by gavster; 04-07-2009 at 08:33 AM.

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