+ Reply to Thread
Results 1 to 4 of 4

Formula to match 2 tabs to give 1 result.

  1. #1
    Registered User
    Join Date
    05-08-2015
    Location
    Middle of Nowhere
    MS-Off Ver
    2010
    Posts
    38

    Formula to match 2 tabs to give 1 result.

    I need to compare 2 tabs data to give me 1 result For example
    Tab 1
    100001125 2155
    100001125 2160
    100001125 2235

    Tab 2
    100001125 2155 Joe
    100001125 2160 Jeff
    100001125 2235 James

    I need it to put the Name next to the appropriate account # and company. What kind of formula would I use?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,508

    Re: Formula to match 2 tabs to give 1 result.

    where are you putting the name - into TAB 1
    and also i assume tab1 is columns A and B and tab2 A,B and C

    =INDEX(Sheet2!C1:C100,MATCH(A2&B2,Sheet2!A1:A100&sheet2!B1:B100,0))

    then use Control +shift +Enter to enter as an array and get {} around the formula
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-08-2015
    Location
    Middle of Nowhere
    MS-Off Ver
    2010
    Posts
    38

    Re: Formula to match 2 tabs to give 1 result.

    Thanks your awesome exactly what I needed

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,508

    Re: Formula to match 2 tabs to give 1 result.

    your welcome

+ 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. What formula do I require for two criteria to match in order to give result?
    By samuelleach in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2015, 12:30 PM
  2. [SOLVED] if formual how to use in two conditions, or any formula to give result from sum of two dat
    By raysrains1310 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2015, 08:49 AM
  3. seach and match to give result
    By prasjohn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2009, 06:19 AM
  4. match 2 colomns to give result
    By semo in forum Excel General
    Replies: 2
    Last Post: 05-28-2009, 06:31 AM
  5. Provide a match from 2 cells to give a result from another
    By leefarrell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2006, 08:34 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