Results 1 to 9 of 9

Thread: Index Match a col of long text stings to find short text strings and return adjacent

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    This array-entered formula in C2 then copied down gives the same results as you wanted, but that may be just luck. See attached file.
    =MAX(IF(ISERROR(SEARCH($A$2:$A$52,D2)),FALSE,$B$2:$B$52))
    (Array-Entering is pressing Ctrl+Shift+Enter rather than just Enter.)
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •