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?
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?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.Originally Posted by Excel Fox
Can be done. Can you post a sample file and show the expected output also.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
I have attatched the file. Can you please write a vba and formula, if any, for the task?
Regards,
Safal
Try this formula:
Copy below formula and apply it with CSE and drag it down:
=IFERROR(INDEX(thingstodo,SMALL(IFERROR(IF((things todo[Date]=$D$11),ROW($A$1:$A$100),""),""),ROW($A1)),2),"")
I can't drag it down. I need it to be automatical. So I was asking for the loop.
Regards,
Safal
Then it can be done with the help of VBA Macro. Is it Ok?
Posting Permissions
Reply With Quote
Bookmarks