Need some VB.NET code that will look up values in one array based upon values in another array

I have VB.net code that creates a Dictionary. The information can be converted into a multidimensional array, with PMID, ISSN and YEAR. Every Article is Published with a unique ID in a Journal that has an industry assigned unique ID in a particular YEAR. So, my data can look like: PMID ISSN YEAR 29374060 0007-9235 2022 29618665 1471-0072 2022 29662628 1740-1526 2022 29735528 0007-9235 2021 29748384 0007-9235 2022 29844859 0140-6736 2022 29871931 0007-9235 2022 29876004 0140-6736 2021 29983887 0028-4793 2022 29996914 0140-6736 2021 29996940 1474-1776 2021 The PMID is unique but the ISSN and YEAR can and will be duplicates. They could be 1000 rows. I need to add values to the array that are stored in another table. The structure of the other data is open to discussion, but both are provided in smaller samples. I need the most efficient application because this table could have 10,000 rows. Structure A: Could have each Year as a separate Row or Structure B could have each Year and values as separate columns, but I could have 20 years of data. Structure C could have each Year as a separate data file. The majority of the data will come from 2018 up to the current year. So I might be able to manage total row object to 10,000 or less. Open to suggestions and a working proof of concept. Excel Spreadsheets have been provided with data. Hopefully your option is a little more efficient then looping the data table for each element in the object table. ISSN ESSN YEAR Full Journal Title Impact Factor 0007-9235 1542-4863 2022 CA-A CANCER JOURNAL FOR CLINICIANS 508.702 1471-0072 1471-0080 2022 NATURE REVIEWS MOLECULAR CELL BIOLOGY 94.444 0028-4793 1533-4406 2022 NEW ENGLAND JOURNAL OF MEDICINE 91.245 1474-1776 1474-1784 2022 NATURE REVIEWS DRUG DISCOVERY 84.694 0140-6736 1474-547X 2022 LANCET 79.321 0007-9235 1542-4863 2021 CA-A CANCER JOURNAL FOR CLINICIANS 308 1471-0072 1471-0080 2021 NATURE REVIEWS MOLECULAR CELL BIOLOGY 35 0028-4793 1533-4406 2021 NEW ENGLAND JOURNAL OF MEDICINE 31 1474-1776 1474-1784 2021 NATURE REVIEWS DRUG DISCOVERY 34 0140-6736 1474-547X 2021 LANCET 39 The uniqueness is based upon the ISSN and the YEAR. Please do not low ball bid then ask what's my budget. If I chat with you my budget is your bid.