Return value in column B corresponding to the value in column A in Excel

Hi all,
can somebody help me to identify which node to be used for getting the value in Column B corresponding to the value in column A in Excel.

This is the excel I have.
image

Thanks in advance.

Can you show us what you’ve tried so far in Dynamo? :slight_smile:

Thank you for the response.

Sure.

This is what I’ve done so far.

Here I want to replace the List.GetItemAtIndex node.

Hi there,

you could try to use this:

1 Like

You probably want a dictionary node

1 Like

As Andrew_Hannell said, you could use Dictionary nodes from LunchBox packages:

Cheers

1 Like

Thank you… That helped… :slight_smile:
But i used the node List.AllIndicesOf node instead…

Will try that also… thank you so much…

Thank you Andrew.

:slight_smile: