Thanks Faseeh, the list entries present 1)AA-BBC & 2)BBC-AA for the lookup value as AA, however I was looking to get only AA-BBC & not BBC-AA as AA-BBC starts with AA (then the second match that starts with AA), whereas BBC-AA starts with BB and not the lookup value (AA).....
(EDIT Added - to...
Thanks Faseeh....From the two questions, for the second this is exactly what I was looking for...
This can be used for "contains".....any idea how can we incorporate for "begins with" .....
THANKS AGAIN...
In the formula
=Index(range1,small(if(range2=cell,row(range2)),row())
when dragged gives me the first cell match, second cell match & so on.... is it possible to get match that begins with or contains...something like
=Index(range1,small(if(range2=cell&"*",row(range2)),row())...
Perfect....Narayan Thanks
Small Man thanks but I was looking for a UDF
EDITED (SirJB7)
Whenever you reply a post, take care of writing the new text off the quoted section: [ QUOTE ] [ / QUOTE ]
Hi Friends,
I have three range of data, lets say C2:C40, E2:E40, G2:G30 through some formula this range gets populated (a few cells goes as blank "").
I was wondering if someone can help me get some UDF (again UDF) to get the unique values from this range in I2:I40...
Image link...
Firstly, this isn't exactly an excel question but related to help in creating a RAG/Dashboard stuff in excel.
Background: The boss just called me in and explained the following - We have plans to migrate some work from onshore for which we will be hiring candidates. We have the actual...
The big challenge is we are using an outdated version of forum software. We cant update it as the developers abandoned bbpress almost 2 years ago.
+1
Definitely need a change...and if you are changing...please have a thanks or like or +1 added to it....please I beg :(
Just because you appreciated my username... don't know give it out a try...
https://docs.google.com/file/d/0B0kxdNrvyzqzVzRxQ3VaUDg2aEk/edit?usp=sharing