Hi all. I’m trying to get the value of a cell right next to another which has a specific string in it which I can search for. Please refer to the attached screenshot.
I need to look for the value in red; “Reviewed and signed off by Senior Manager:” and get the value in the cell next to it in yellow, so in this case the value I’m looking to return is: “NAME OF MANAGER”
Here are some caveats:
- The columns don’t have headers
- The ‘search string’ can be anywhere on the page, they can add in an extra row, column etc. so I cannot hard code the col or row reference of where to look for the ‘search string’.
Here is what I’ve tried so far:
- I loaded the excel into a DataTable using Read range. Then I used LookUp Range to get the cell reference for the search string (which can be anywhere in the excel). However, now I’m stuck, because all I have stored in a variable is a string, like A16. How do I now get the value in B16?
- I also tried using the LookUp Data Table Activity, but it requires me to specify something about the location of the lookup, such as ColumnIndex or Name etc.