Update Cells

[anmita]

Hello Everyone,

Is there a way to get the Cell Value based on the column no
Example : When we get no 1 then the Cell Value=“A”

Column No|Cell Value
1 | A
2 | B
3 | C

So basically based on a column no parameter can we define the cell value to be considered

Thanks and Regards
@anmita

[arjunshenoy]

Hi @anmita

Can you please specify whether you want to update the cell value for a specific column number or you want to fetch the cell value for a specific column number.

Best Regards.

[Anil_G (Anil Gorthi)]

@anmita

You can use look up activity…which will look up the value in column No and can return the value from Cell Value column

On Excel

LookUp Range

On Datatable
https://docs.uipath.com/activities/lang-pt_BR/docs/lookup-data-table

cheers

[pawanrajpurohit]

Main.xaml (7.0 KB)
Here is your solution @anmita

[anmita]

Thanks @pawanrajpurohit