Get value from column B based on Column A

Hi, I have an excelsheet with dates in Column A and different values in Column B. I need to bring back the value from a picked date. Picked date is stored in a DateTime Variable. I want to get the value from picked date in a new variable. Any suggestions?

@ringan Try select statement on datatable after reading excel.

String Output = dt.Select("[ColumnA Name]=’"+datevaraiable+"’")(0)(1).tostring

Where dt is datatable which contains excel data.
You also need to check the date format in excel after reading.

3 Likes

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