Returning multiple value for lookup table

[Yoichi]

Hi,

If you datatable is like the following image, the attached sample will help you.

arrBank = dt.AsEnumerable.Where(Function(r) r("CompanyName").ToString="B").Select(Function(r) r("Bank").ToString).ToArray()

Sample20221119-2aL.zip (2.7 KB)

Regards,