My column structure is as follows:
Column A: SKU AD01, AD01, AD01, AD01, AD02, AD02, AD02, AD02, AD03, AD03, AD03, ... Column B: empty Column C: SKU AD01, AD02, AD03, ... Column D: ID 1, 2, 3, 4, 5, ...
The idea is to match the SKU from Column A with the SKU from Column C and output the ID from Column D to Column B.
SKU's in Column C are unique. SKU's in Column A are not.
What is the best way to do something like this?