Revit family with Index formula

[jan.appelgryn]

Good afternoon,

I have this formula in Excel that look and compare two columns and give the values of the 3rd and 4th columns if both are true, I want to use this in a RVT family, can anyone help please. Below is the table that will run from a csv lookup file.

=INDEX($C$3:$C$895;MATCH(H4&" "&I4;$A$3:$A$895&" "&$B$3:$B$895;0))

The formula must resolve when ND_Main (column A) and ND_Red (Column B) is in the same row (Row 5) in the csv file and then return the values that is in Column C (for the value in Column A) and Column D (for the value in Column B)

See the atachment

Thanks in advance

Jan

[timlove]

A lookup table does not work with a formula like that. 

https://help.autodesk.com/view/RVT/2022/ENU/?guid=GUID-91270AEF-225A-49D7-BF84-1F44D1E3E216

result=size_lookup(LookupTableName, LookupColumn, DefaultIfNotFound, LookupValue1, LookupValue2, ..., LookupValueN)

So if you wanted to get the value in ColumnC, when A and B have a set value:

result=size_lookup("MyTableName", "ColumnCName", "Did not find matching data", ParameterToMatchColumnA, ParameterToMatchColumnB)

Repeat to get your value for D.

Typically I will create a formula instead of reporting an unusable value, but it depends on what data you are retrieving.

[jan.appelgryn]

Hi, thanks for this, but it seems that my formula skill need some upgrade, I did not used this, I created a simpler version where I have if statement to the value if needed can be filled in. Thanks for your advice.

Kind regards

Jan