Hi I need somebody to create a macro to use for with a VLOOKUP function. I have 2 excels, 1 is the original and the other ones is the one were I want to send the info.
On the original I have a column where the "searched value" is repeated but the value given is different (please see attached). On the other excel I want to receive this value given for every repeated searched value. When doing a normal VLOOKUP it just give the first value.
If somebody knows how to write this macro it should be an easy task.