Hi

I'am working on the subject to show throw from air terminals in revit mep.
i want to create a lookup table that based on the air flow in the terminal sets the korrekt throw radius.

i have the numbers for the throw length based on the flow but how do I make it as a lookup table ?
as it is now imusing if statements in the family but its a slow process.

for an lindab lcp airterminal it looks like this:
if(Flow < 25 L/s, 1000 mm, if(Flow < 60 L/s, 1950 mm, if(Flow < 85 L/s, 3000 mm, if(Flow < 110 L/s, 4000 mm, if(Flow < 160 L/s, 5000 mm, 2500 mm)))))

I want to make it in a lookup table as, if flow = xxx then look up R=xxx

best regards

kasper