Hello. I am working with Latin vocabulary lists. I have one list in a sheet named “Bridge” and a second in a sheet named “Dwane”. There are columns in both sheets named “SIMPLE_LEMMA”. I would like to match multiple values from the “SIMPLE_LEMMA” column and pull the data values from a column in the “Dwane” sheet that does not exist in the “Bridge” sheet. In other words, import this “DERIVATIVES” column into the “Bridge” sheet, matching up on the corresponding “SIMPLE_LEMMA” row.
In the “Bridge” tab, the “SIMPLE_LEMMA” column is column B, the second column, and I would pull the data values into column M (13th column). In the “Dwane” sheet, the “SIMPLE_LEMMA” column is column B (second), and the “DERIVATES” column is column E (the 5th column).
Is there a functions maven out there for whom this might be a cinch? Thanks in advance if you can help.