Allow text in lookup tables

[Anonymous]

It sure would be nice to use text in lookup tables.

[GallowayUS_com_RonAllen2]

Also-

size_lookup(LUT.FLANGE, "id.CLASS.DESCCRIPTION", "NOT FOUND IN TABLE!", NOMINAL.DIA)

Returns a !NOT FOUND IN TABLE which would be useful for substituting z (\) graphic for an invalid selection.

https://forums.autodesk.com/t5/revit-mep-forum/lookup-table-text-value/m-p/4890146#M22624

[rschoch]

We should be able to add text to any column in a lookup table. but..

You can use the first column in a lookup table for text.  To report it use a formula like this.

size_lookup("LookupTableFile","","Invalid Text",SecondColumnParameter,ThirdColumnParameter)

Multiple types of text strings can be in a single lookup table, you just need to add the data vertically and not horizontal.  Use the second and third column to separate data types like part number, description, model, etc.  Use intergers/angles/lengths to separate the data type.