Search a known value in excel and return a value of the same row but with a different column

Help StudioX
, ,
1

I need to store the corresponding Column B value of a given Column A value in a variable and use it in the succeeding steps of my automation. How do I get the value of Column B?

2

Hi @Gonzales_Paula_Jane ,

Use Lookup Range activity of Excel Application Scope and get the address of the cell containing the searched value.

Later use string manipulation to get the desired cell, corresponding to the searched cell.
Pass this value in Read cell activity, this will give you the desired result.

For eg - Suppose you get the address of the given value from Column A in ‘A11’.
String Manipulation - "B"+add.Substring(1) , this will give the result as ‘B11’.

Pass this in read cell activity and you will get your result.