Search for Data in Excel - table

Hey everybody,

I would like to search for a few entries in my Excel - table. I get from a other Excel - File the relative Humidity und the Temperatur, but I have Problems with these Excel - table.

I would like to have the yellow cells in the Excel - table. Unfortunately, I have no approach. Has anyone ever done something like that? I would be really grateful for help. I’ve been sitting there for a while and think about it, but without result.

I created the excel table myself and could possibly change it structurally if necessary.

best regards

Hello. Can you upload your excel file? It would be easier to test if you could.

of course, thanks!

Temperaturauswirkung.xlsx (16.2 KB)

Sorry was gone for the weekend. Try this graph:
temperaturfromexcel.dyn (22.8 KB) - Dynamo 2.0.x

Hey, thank you for your help. Your method of reading the table is very elegant!

But I have the Problem, that i can not find ,List.IndexOf´´ , is it in a special package? I only have ,IndexOf´´ and I am not sure that this is the right commend.

List.IndexOf is the standard out of the box node. I am using Dynamo 2.0.2 but it should work with any IndexOf that comes with your version of Dynamo.