Excel Lookup Range activity - partial match, multiple matches?

Hi, does Excel Lookup Range activity work with partial matches or minor differences? E.g. I am looking for “Currency” but the Excel sheet may contain fields “currency”, “Currency :”, “Currency: -” etc.

Also, what happens if there are multiple matches and how do you handle these?

It works like String.Contains

what does that mean it works like string.contains? I get how to use string.contains but how do i use it in the lookup?

Hi @Asanka,

To use lookup range activity, you need to use in Excel Application Scope. In the properties of lookup range activity, you just need to put the sheet name, and the keywords that you want to find. For example, if you want to find “Currency”, you need to write it as it is and you will get the output in which cell the keyword is.

Hope this will help.

Best Regards.

Here is the exact video: https://www.youtube.com/watch?v=R5-UMlh2EWY