LinkBack URL
About LinkBacks
=ADDRESS(MATCH("*"&B1,A:A,0),1) where b1 contains defg
=ADDRESS(MATCH("*"&B1,A:A,0),1) where b1 contains defg
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Im afraid that didnt work, i have attached a sample workbook which should explain what i am aiming to do?
you can just alter Martin's original and add a 2nd wildcard post partial string, ie:
=ADDRESS(MATCH("*"&B1&"*",A:A,0),1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks