Look up value

Help Activities
, ,
1

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.

2

Hi @karan_kapoor1

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

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

Thanks.

3

which activity should i write this line to?

4

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