How to Increment Cell reference variable

[nilesh.mahajan]

Hello,

I have used Lookup Range to get the cell reference by Value and getting the desire output, but now want to Increment that. I mean If I get H3 then need to increment that As K3.
The Purpose is I want update the status against the value which is in H Column and that might be in any row number, So by finding that value in H column update the remark in K column in same Row.

[Anil_G (Anil Gorthi)]

Hi @nilesh.mahajan

Look at this

Getting column index from Excel

Hey guys! Me again I want to get the column index/letter for column named “Group” from an excel file. The column can move a lot, but all I want is the column index/letter (e.g. A, J AB, C, D) that corresponds to it Can anyone help?

Elae use this xaml

https://forum.uipath.com/uploads/short-url/b6Y6CQTt9aRJmCa6DpQrUu9kSvJ.xaml

Just add 1 and you will get next column

Cheers

[Rahul_Unnikrishnan]

Hello @nilesh.mahajan
Please check the below.

You can use lookup datatable activity.

How can i get the column index from lookup data table property. for example i used lookup tp find value at a particular cell in an excel, now i want to get the row and column index for this cell and use it in the flow?

[image]

Thanks