Quote Originally Posted by Excel Fox View Post
So what is it that you want? Do you want to loop through a column and return the values from an adjacent column, and give the values from there when the value in the first column matches the value you are looking up?
You are right I want it to return as normal vlookup do. Like if the lookup value is repeated in a column, it want it to return every result.