Look Up Table help

[Jes_Gonzalez]

Hello peeps, I'm having an issue with look up table. I'm no pro i'm on revit 2018.3 and my question is if its possible to create a look up table to also contain text and numbers. My goal is to create a look up table with for instance a ball valve family, so this family will have different sizes and i want the part number to change with the size. This what i have so far. My look up table works perfect but i'm scratching my head trying to add text with number for product numbers. I know it should be in length or inches.  Any help will be greatly appreciated.

[barthbradley]

Might be too convoluted, but you could do an integer which would be evaluated through an if statement in the family to return a text value. 

if(integer=1, "N1", if(integer=2, "S3, if(integer=3, "U7", ....

[Jes_Gonzalez]

I was looking for something anyone can edit with knowing much of revit families. Goal is to have a look up table along with part ids and as they change have someone edit and reload the look up table.

[Jes_Gonzalez · Accepted solution]

Figured it out.

Make sure to add your text on the 1 column like the highlighted.

size_lookup(Look Up Table, " ", " ", D)

[barthbradley]

Huh? Not sure I understand your solution. What does size_lookup(Look Up Table, " ", " ", D) do? It's not an evaluation.  What value is returned?  

[Jes_Gonzalez]

Sorry, I wanted to use a look up table to keep track of product number that consisted of number and text. So for instance if i have 1/4" valve it will retrieve HPH25 and autosize to whatever the pipe diameter is. So in the future if we need to change/update product numbers all we have to do is update the .csv file and reload the family.