I've been trying formula's like vlookup, index, match etc... from previous solutions with no luck so I'm writing this request.
Can you tell me how to search for a value from col c in col m and when found in col m fill in the corresponding value from col a into col d.
col a range is A2:A53
col c range is C2:C53
col d range is D2:D619
the match search range is M2:M619
Does each cell in the D column need a formula?
Is this better solved using VB Script?