Lookup Address Values - Unique Values

Hi Everyone,

I am working on excel based scenario wherein i want to return cell address of every “Stock Symbol” in column “Location”

However, in output for some of cells(Highlighted in red), its returning address - “A1” - It should have returned “B9” for “*” symbol and “B21” for “?” symbol, May i know why is this happening ?

Am i missing something ?

My workflow :–>


It’s because * and ? are special characters in lookup. Can you try to escape it using ~ as the following?

row_symbol = row_symbol.Replace("*","~*").Replace("?","~?")



Perfect, thank you, appreciate your help.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.