Read value in excel-cell based on neighbour cell


I would like to read and save a value from a specific cell neighbouring to one cell that is selected.

I.E. I enter a specific code that the robot finds in an excel sheet, then I want to read and save the value from the neighbour cell on the left hand side of it.

The cells are dynamic so it is not possible to select one static cell.

Thanks in advance

Hello, you can use a For Each Row activity to iterate through rows and then a For Each to iterate through columns, if the item matches the value you are looking for, you can extract the index of rows and columns and extract the element you are looking for.

Think of the DataTable as a Matrix.

Did I explain myself correctly?


Kind regards,

You can use vlookup to get the cell value and increment to next value and read it