Results 1 to 16 of 16

Vlookup - create new list from existing list based on partial match

Threaded View

  1. #1
    Registered User
    Join Date
    05-12-2018
    Location
    UK
    MS-Off Ver
    2010
    Posts
    9

    Vlookup - create new list from existing list based on partial match

    I'm trying to use formulae only to create a new list of data from a master data set using criteria in a lookup column.
    I'm hoping for my formula to follow these steps:
    1 Take value in E3.
    2 Lookup cells in A3:A14 partially containing value in E3.
    3 When a match is found, stop, copy complete value in column A plus adjacent value in column B. Add value to H & I column (H3:I3 for first entry in example)
    4 After first entry, formula will move to next row in column H (H4)
    5 Move to next row in column A and continue lookup.
    6 Repeat step 3 & 4 everytime a match is found.

    This is pretty much the jist of it. I'm new to formulae in excel so any help would be appreciated.
    vlookup is great but couldn't combine with other function to do step 4
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare a list of strings against a list of keywords to return a partial match
    By randomkiwi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2017, 11:51 PM
  2. [SOLVED] Updating a Master List from a Partial List (VLOOKUP?)
    By jplunkett1 in forum Excel General
    Replies: 7
    Last Post: 07-15-2016, 11:19 AM
  3. [SOLVED] Formula to Create a Partial List from a Complete List
    By slindfors in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 02:44 PM
  4. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 03:52 PM
  5. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:02 PM
  6. Copying row based on partial cell match and paste into existing worksheets
    By colinh69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2011, 02:42 PM
  7. Replies: 1
    Last Post: 06-05-2006, 10:40 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1