Results 1 to 8 of 8

VLOOKUP partial match not playing the game

Threaded View

  1. 07-14-2016, 04:26 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: VLOOKUP partial match not playing the game

    ARRAY formula In Row 2, then drag down.
    =IFERROR(INDEX(Table1[Total],SMALL(IF(ISNUMBER(FIND("/"&'Test Data'!B2&"/","/"&Table1[W/O]&"/")),ROW(Table1[W/O]),""),1)-ROW($A$2)+1),"")
    Pl see file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel vlookup partial match for URLs
    By tonyuk001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2014, 12:58 PM
  2. Vlookup with only partial text match
    By betsy2128 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-18-2013, 08:03 AM
  3. [SOLVED] modified vlookup for partial match
    By jlax34 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2012, 02:07 PM
  4. [SOLVED] VLOOKUP with partial match
    By Nekk in forum Excel General
    Replies: 7
    Last Post: 06-28-2012, 11:46 AM
  5. Partial Vlookup Match
    By OptionTrader in forum Excel General
    Replies: 12
    Last Post: 11-15-2009, 08:28 AM
  6. Vlookup - Partial Match
    By VegasL in forum Excel General
    Replies: 8
    Last Post: 06-08-2008, 03:25 AM
  7. Partial String Match Using VLOOKUP
    By cdhmotes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2005, 06:30 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1