Hello, I have tried this for sometime now but maybe i'm missing something. I'm trying to use VLOOKUP and the range that i'm searching in could have multiple occurences of the lookup value. I want to get all the instances of the lookup value. I have tried to use array formulas with VLOOKUP and MATCH but nothing seems to have helped with this. After getting this done I would want to implement the solution through VBA. Any help with this is greatly appreciated.
Thanks for the help in advance. Gaurav!!!!!!!! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
