Look up Datatable

Help Studio
1

Hi,

I want the values of Run1 and Run2 of Particular city like “Bangalore” and paste these in a table in the word document. I have highlighted the values. How can I do this

image

Regards,

2

Use read range to get your data to datatable starting from row 10 (don’t use headers).
After that lookup datatable dtSourceData and taking the index number where the value was found.
If intFoundIndex <> -1 then strRun1 = dtSourceData(intFoundIndex)(2).ToString
strRun2 = dtSourceData(intFoundIndex)(3).ToString