I need to fill a
Products table in
file A with their manufacturing costs that are in another
Costs table in
Currently, I read
Costs tables into their respective arrays and for each product I iterate over each cost looking for the right one. Basically, VLOOKUP done with arrays.
O(n^2)? I feel like there should be a better way to do this. Should I use ADO? Dictionary with key as a lookup value?