I have a data list of 48000 entries of which all cells are filled and
complete. I then have another list that has 300+ entries that has 4
cells within each with missing information. I was needing to know a
way to populate these cells with either a formula or a macro to take
the corresponding/matching cells within the first list to populate the
second.

Thanks