lookup a value in a list in dynamo

[wanfosin]

I hope any someone could provide me a dynamo script for finding the index in a list in excel using dynamo.

It is something similar to the command VLookUp in Excel.  Only issue is that I am looking for a script using Dynamo.

Thanks.

[jeremytammik]

This sounds more like a generic Python question to me, assuming you are using Python. This has nothing to do with the Revit API, as far as I can tell. Therefore, you might well be better served asking it in some other more appropriate forum.

[wanfosin]

Thanks.

I was actually intend to do generative design using Revit-Dynamo and Refnery.

Unfortunately I was advise by Autodesk to stay away from Python when doing generative design.  That was why I was asking for this as I could not find a commant or steps to do this.  I can only gave the item and a generted list from a table in Dynamo.

[PavelAnd]

Hi @wanfosin. You can use Data.ImportExcel node for getting Excel data. You can download the script for finding the value from excel data in the attachment below.