How to find row index of string in excel

Hello,

How to find row index of particular string in excel.

Hey,
You can follow this screenshot


Thanks

Hey,
follow this

DT.Asenumerable.Tolist.Findindex(Function(r) r(ColumnName).To string.Equals(String_Variable))

I get string value dynamically from one excel and search on another excel

You can use lookup Data Table ACtivity

Thanks

vDTData.Asenumerable.Tolist.Findindex(Function(r) r(Company Code).Tosrting .Equals(str_value))

it gets error on tostring


Here you can see
DataTable- In which excel you want to search-ReadRange-DT1
LookUpValue- That value you are searching For
ColumnIndex- In which column you are looking for Index starts from 0
CellValue-Output- which value you want
ColumnIndex- Refrence ColumnIndex
Thanks,
Rounak

it get β€˜-1’ row index

Hi,
Follow this video about row index

Thanks it’s solve

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.