Results 1 to 4 of 4

Thread: Help with lookup table and formula

  1. #1
    Junior Member
    Join Date
    September 8, 2016
    Posts
    33
    Current Local Time
    01:08 AM

    Not allowed! Not allowed!

    Help with lookup table and formula

    Hello,Please look at attached. I don't know why revit is not taking value from lookup table, but only 'DefaultIfNotFound'.

    Thank you
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Formula.PNG 
Views:	25 
Size:	247.6 KB 
ID:	38503  

  2. #2
    Member
    Join Date
    December 11, 2010
    Location
    Astana
    Posts
    216
    Current Local Time
    07:08 AM

    Not allowed! Not allowed!
    Hi,

    Try to make the column names match the parameter names or vice versa.

  3. #3
    Junior Member
    Join Date
    September 8, 2016
    Posts
    33
    Current Local Time
    01:08 AM

    Not allowed! Not allowed!
    Quote Originally Posted by Nurlan View Post
    Hi,

    Try to make the column names match the parameter names or vice versa.
    Hi,
    It's not working. I changed parameters name to match columns, cause when I try to change columns name and put it in formula it gives 'invalid input' nonsense.
    Last edited by baggins79; March 6th, 2020 at 06:22 AM.

  4. #4
    Member
    Join Date
    December 11, 2010
    Location
    Astana
    Posts
    216
    Current Local Time
    07:08 AM

    Not allowed! Not allowed!
    The names and type of parameters must match the lookup table.
    Your formula is looking for a match of two values (ND1 and ND2) in a row, if there is no match, then the default value is substituted.

Similar Threads

  1. inconsistent units, problem with formula linking too lookup table
    By wackadoodle in forum Architecture and General Revit Questions
    Replies: 0
    Last Post: July 13th, 2018, 10:52 AM
  2. Lookup table
    By gowthamsamys in forum MEP - General
    Replies: 2
    Last Post: April 16th, 2018, 09:48 PM
  3. Lookup Table Using Number
    By Tim_Ea in forum MEP - General
    Replies: 5
    Last Post: January 31st, 2018, 02:03 AM
  4. Lookup Table: First Column?
    By doni49 in forum Architecture - Family Creation
    Replies: 3
    Last Post: September 27th, 2015, 11:09 PM
  5. Lookup Table issue
    By sabari2504 in forum MEP - General
    Replies: 8
    Last Post: January 15th, 2014, 08:19 AM

Posting Permissions

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