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
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
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.