Excel get value from Excel based on other value

Hi Robin,

Thanks for your reply but this is not perfect solution because this is returning multiple values that to in list variable.

I have figured out solution my self.

We can use below query

Convert.ToString(Dt.select(“Month=‘May’”)(0)(“Yellow sales”))

This is working perfectly.

Thanks for your replies.

1 Like