Look up value

Hey friends need some help,

I am using a look up range to search a particular value in an excel file.
Giving an example below.

In column A i have values such as
abc
xyz
qwe
asd
yz

If i put look up range and i put the the value to find as “yz”, it points out to the cell containing xyz value in the cell where as need only yz.
Could you help me out.

Hi @karan_kapoor1

Instead of lookup range, you can try select function to get the value.

YourDT.Select("[YourColumnName]=‘yz’").CopyToDataTable

Thanks.

which activity should i write this line to?

Use assign activity and change data type to DataTable. Thanks.