How to scan excel to get specific value

Lists-Logic
1

Hi all,
I am new to use Dynamo, I have a data in excel, all i want is to go inside the excel table using 2 values as input, and get one value as output for each element in Revit.

Pasted image1357Ă—857 78.5 KB

2

Hi @JohnGhaly

Welcome to Dynamo Forum!
You can use “FilterByBoolMask” node along with “==” node. You can use search bar on top to get examples how to filter lists.

3

Hola JohnGhaly, tal vez este enlace te sea de ayuda How to read a specific cell from Excel?

4

Thanks All, i got it
But i have a small issue.
now i have 2 lists with 65 sub list each, i need to scan the List 1 ( Values ), and get the value corresponding to the index token from list 2 ( Index ) for each sub list as shown in first image

i used list.map & list.get item at index, but dynamo did it for every item as shown in second image

Thankss

5

image.jpg680Ă—844 110 KB

6

01.JPG1050Ă—532 45.5 KB

7

Is this what you are looking for?

1 Like
8

Yes, same concept of this :+1:
Thankssss