Lookup Address Values - Unique Values

[Neal369]

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 :–>

[Yoichi]

Hi,

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("?","~?")

Regards,

[Neal369]

Perfect, thank you, appreciate your help.