+ Reply to Thread
Results 1 to 3 of 3

Best Method... Range.Find or Index.Match?

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    96

    Best Method... Range.Find or Index.Match?

    Hey yall,

    Im stuck in a rut (thought) right now and i really need to get on a different path.

    Situation/Objective: I need to validate two cells on one worksheet, and if true then i need to find the cells data on another worksheet(same row), & copy/paste that entire row(or 'add' the other 8 columns of data) back where the cell data came from. Currently im in a For Loop for each row of data, but then entering an index.match into each cell to pull the data... i know this isnt the right way, and im having trouble with the "Column & i" reference in them.

    i guess i just need to loop a Range.Find using multiple variables. ?? Someone told me this, but i dont know if it works in what im trying to do.

    Anyway, im hoping someone has "the" answer, instead of my makeshift ways of arriving at a location. Thank you in advance!
    Last edited by Quint6778; 02-28-2017 at 09:15 AM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Best Method... Range.Find or Index.Match?

    As i assuming if original data in sheet1 & required result in sheet2. Condition if "True" then data pull & if false then blank (no data pull)
    using index match with criteria True & name.
    Plz refer attach file.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    11-14-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: Best Method... Range.Find or Index.Match?

    This may work but ill be running this thru vba and it seems id have the same difficulty adding that formula to each of the cells, no? I attached your spreadsheet with 2 new tabs for reference.

    I need to fill in the rest of the data based on columns A & C in ws"Me2", pulling it from ws"Me1". I started with:
    For i = "A" & UsedRange.Rows.Count
    If IsEmpty "C" & i = False
    And IsEmpty "B" = True THEN
    ....here i would try entering the formula. It just doesnt seem appropriate and im unfamiliar with Range.Find pulling rows

    (i know pieces of the code are missing, just trying to explain my thought process)
    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 to find match date to a range of dates
    By downcrusher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 06:05 PM
  2. [SOLVED] .Find method does not find strings if the # of spaces do not match. Do I need a RegExp?
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2016, 03:59 AM
  3. Find value in range with two criterias, INDEX MATCH MAX
    By gnoke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-24-2014, 07:48 AM
  4. [SOLVED] Which method is faster, VLOOKUP or MATCH & INDEX?
    By Jimmyjazz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2013, 04:35 PM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  6. Find method with 2 criteria match
    By zekethewolf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-12-2011, 11:08 AM
  7. [SOLVED] Summing multiple hits using match, offset and index method
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 05: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