Hi.
I have a list with more than 1000 records and 10 columns, I need to search for a value in a cell and extract some data from that row, and then copy it to a new excel. I find two problems:
one.-
The problem is that I am using “Lookup data table” and it only finds the exact data, but I need to search with a LIKE %%, since that search data varies although it always starts with “SAPA”, I have carried out several tests and none it works.
2.- I need to go through the entire list, I have tried with “for each row” but it always returns the first row.
The following example works, searching for the exact word:
Thaks.