Results 1 to 6 of 6

VLOOKUP based on partial match

Threaded View

  1. 07-03-2017, 11:27 AM #1
    MetroBOS
    MetroBOS is offline
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 365 on Windows 10
    Posts
    122

    Question VLOOKUP based on partial match

    Please help me troubleshoot the formula error in the attached file.

    The goal here is to look at the values in column A, compare them to the values in column F, and if the values in column F are found within the values in column A, return the value in column G.

    The formula is in column B, but it's not working.

    I put the expected outcome in column D for reference.
    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. Macro| Search 4 partial match then apply IF statement based on blank cell next to match ?
    By axemonkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2013, 09:03 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