Hi team, I have below excel data - [image] I have 2 values - “currency” and “account” First I have to check if [first 2 characters of " currency" ] is present in Remit_ID rows.If it has a unique row match , it should return the corresponding “Supplier_ID” for that Remit_ID. If its present in mu…

have a check at: [grafik] (From d In dtData.AsEnumerable Let sc = strCUR.Trim.Substring(0,2).toUpper Let sa = strACC.Trim.Substring(strACC.Trim.Length - 4).toUpper Let rm = d("Remit_ID").toString.Trim.toUpper Where rm.StartsWith(sc) Or rm.EndsWith(sa) Let cm2 = Convert.ToInt32(rm.StartsWith(sc)).…

Find match for rows in excel

Help Studio

gokul1904 (Glory 01) September 5, 2022, 11:46am 8

Yes Input is coming from outside - currency and account are input variables here.

We have to match the input variables with each row of “Remit-ID” column and derive the corresponding “Supplier_ID” for that.

Regards,
G

Topic		Replies	Views
Excel help please - filter and fetch values Studio studio , question , activities_panel	7	1099	September 5, 2022
Filter excel data based on a matching rule - if col1 value(account) is same and col2(amount) is matching as debit & credit, need to exract the rows Help excel , activities , studio	1	1564	June 6, 2019
Update data table row if a match Help	5	2921	April 1, 2020
Get Value of Second Column each row Help	1	2043	April 8, 2019
Compare the value is there or not in excel and get the corresponding column value Studio studio , question , activities_panel	5	1106	February 12, 2022

Find match for rows in excel

Related topics