Read excel and get value by name


I’ve just started to work with excel file reading. So i have a question. I want to get the “Value” by “Name” from Excel. The name is in variable and it’s dynamically changed. So i need to find the name and get the value by name.

There is how it’s look in my example:

Any ideas how to do that?

@sjankus Uipath must accept the name for that particular value must be displayed? Am i correct or any other output ur accepting.

Hello Manjuts90,

Thank you for the quick reply. I need to get only “Value”.
For example if i am searching John then my result must be only “15.30”. All the names are unique.

test.xaml (6.4 KB)
You can try this, should work the way you’ve described. You can use LINQ to filter values like this.

Hello, @KatKon!

Working fine! It’s exactly what i need.

Thank you!

@sjankus Try below workflow.
del-------------.xaml (12.6 KB)

input excel:
sh2.xlsx (8.3 KB)