How to find the exactly value

Help
#1

Hello everyone

I have an excel sheet that has a column “SQL Server Database Admin” and another one called just SQL
but there is a moment when my robot lookup the sheet searching for SQL and it brings to me the column “SQL Server Database Admin”, but I need the “SQL” column.

There is a way to look for exactly value ?

Thanks in advance

#2

Here ,in the look up you can Expand the search String to Complete “SQL Server Database Admin” and not just SQL.

Other way , Rename the SQL Server Database Admin to “DB Admin SQL” in Excel.

–
Mukesh

#3

But, in this case, I need to search for a column SQL, if I expand the search string to complete “SQL Server Database Admin”, i won’t find the column SQL, understood ?

And I can’t rename the column as you said, because the robot get this value from a web page.