+ Reply to Thread
Results 1 to 2 of 2

Index Match Formula, or VLookup not helping with this problem

  1. #1
    Forum Contributor
    Join Date
    01-14-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    108

    Index Match Formula, or VLookup not helping with this problem

    Good day

    A unique and first time problem for me. I would appreciate help if someone came accross this before.
    I need to look for numbers as per the below which are all listed in Column Y on the Sheet named "Orders"
    Seals
    22464001839304, 22464001750012, 22464001839298

    in a different sheet called "Returns" Column W, as listed per the below.
    Seals
    20162007930163, 22464001839304, 22464001750012, 22464001839298

    From this you can see it is not always an exact match and sometimes the sequence changes. If the search match @ least 2 of these number it needs to return the number from the sheet "Returns" as shown in Column H in returns to the sheet for orders Column I

    Please any suggestion for a formula or Macro would be greatly appreciated

  2. #2
    Forum Contributor
    Join Date
    01-14-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Index Match Formula, or VLookup not helping with this problem

    I have attached the file in the hope of geting a solution to my problem

    Please assist
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index, Match and Vlookup problem
    By trumpetman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2013, 05:15 PM
  2. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  3. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  4. VLOOKUP / INDEX / MATCH problem
    By claytorm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2007, 11:35 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