Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Index Match
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Jan 2017
    Location
    Minnesota,USA
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index Match Help

    Quote Originally Posted by Marcelo Branco View Post
    Try

    B2
    =INDEX(tbl_Item[VERIFY],MATCH(1,INDEX(--ISNUMBER(SEARCH(tbl_Item[ITEM ID],[@[Folder ID]])),),0))

    M.
    Marcelo and AryaTech,
    Very much appreciate the help I was able to get both formulas to work as needed. Thank you for your help!

  2. #12
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,267
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Index Match Help

    You are welcome. Glad we could help

    M.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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