How to get particulate cell value based on another cell value in excel

[Raja.G (Mr.RPABot)]

Hi Guys,

I want one cell value based on another cell like,

For example:

Cell:
A2=ABC B2=XYZ
A3=DEF B3 =UVW

Once i give ABC automatically get XYZ
i give DEF automatically get UVW

Please anyone help me out from this

Regards,
Raja G

[Pradeep_Shiv]

Hello @Raja.G,

do this
Assign
listStrVar = (From row in dT.AsEnumerable() where row(“Column1”).ToString.Equals(“ABC”) Select row(“Column2”)).ToList(0)

Cheers
@Raja.G

[NIVED_NAMBIAR (NIVED N)]

Hi @Raja.G well u try this too

1. use input dialog box to capture the user input and store in input1 varible.

2. use read range to read the excel file and store in dt1

3. use lookup datatable activity by adding below property panel data

   

4. After this use message box to output the output variable

Hope it helps you

Regards

Nived N

Happy Automation

[Raja.G (Mr.RPABot)]

Hi @Pradeep_Shiv,

I want dynamic, if i give ABC or DEF i need opposite cell value , your code is static value ABC can you give dynamic, i add already in contain replace to equal but not accept that code can u help me out from this

Regards,
Raja G

[NIVED_NAMBIAR (NIVED N)]

Hi @Raja.G

I am not sure whether this works

I am just modifying the @Pradeep_Shiv answer a little bit

1. Use input dialog box to get the input value and store in input varaible

2. Use read range to read the excel file and store in dT

3. Use Assign activitiy like this

listStrVar = (From row in dT.AsEnumerable() where row(“Column1”).ToString.Equals(input) Select row(“Column2”)).ToList(0)

Try this way let’s see whether it works

Regards

Nived N

Happy Automation

[Pradeep_Shiv]

Hi @Raja.G,

just pass your inputVar instead of “ABC”

Thanks @NIVED_NAMBIAR

[Raja.G (Mr.RPABot)]

Hi @NIVED_NAMBIAR,

Thanks for your help working fine for lookup activity