How to scan spreadsheet get Intersecting cell

Hi All,

I have a radiator datasheet, I need to select the capacity from looking into its type and length.

image

Progress as of now:
image

How do I get the intersecting cell?

for eg:
image

Hi Arun,

Try this:
select
If you would like to use a number rather than strings check to see that both types are matching (Use the node Object.Type)

1 Like

Using numbers rather than strings.

2 Likes

@A_lee thanks a lot it worked

I tried using numbers instead of string for the size

Can you explain why we cant use strings instead ? Iā€™m unable to search using strings

It is possible to search using either a string or a number but both your data types must be the same (eg. search for a string using a string or search for an integer using an integer, etc.). List.IndexOf requires both to be the same data type to match and locate the element in the list, and will return a -1 if it cannot successfully find any. You can use Object.Type to check the data types as highlighted in the second image.