+ Reply to Thread
Results 1 to 4 of 4

INDEX/MATCH - FIND / trying to figure out if im correct or do i use a wrong formula

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    switzerland
    MS-Off Ver
    2010
    Posts
    15

    INDEX/MATCH - FIND / trying to figure out if im correct or do i use a wrong formula

    Hi everyone - hope youre doing well today

    Im trying to find out if i could use the index/match function in attached sheet.

    There are two sheets with almost the same values - but i need an additional value on sheet1 which u can find in sheet2.

    It doesnt work with the vlookup as it has to match 2 criteria and get me the correct "contactdetails" in column 3 - probably i would add a 3rd and 4th criteria, but not sure yet.

    Attached is just an example / in the origin sheet it has much more columns, but in the end its almose the same as attached...

    i hope i will get some help on this oneXLS_example_IM.xlsx

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: INDEX/MATCH - FIND / trying to figure out if im correct or do i use a wrong formula

    Hi, Ref the attachment
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: INDEX/MATCH - FIND / trying to figure out if im correct or do i use a wrong formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This is also a array function so , Ctrl+Shift+Enter not just enter after copying to c2 in sheet2

    Punnam

  4. #4
    Registered User
    Join Date
    10-09-2014
    Location
    switzerland
    MS-Off Ver
    2010
    Posts
    15

    Re: INDEX/MATCH - FIND / trying to figure out if im correct or do i use a wrong formula

    many thanks guys! you're amazing... even if it look like too easy for you have a good day - and maybe someone could solve my other issue (c my threads)

+ 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. [SOLVED] What's wrong with this Index Match/Row formula?
    By DaveBre in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-25-2014, 08:37 PM
  2. [SOLVED] Help-> Index+Match formula pulling wrong values
    By sashafierce in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2013, 07:13 PM
  3. [SOLVED] IFERROR+INDEX+MATCH Formula is not returning the correct value
    By bxk006 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2013, 09:50 AM
  4. Replies: 2
    Last Post: 04-28-2013, 05:55 PM
  5. Index Max Match formula returning wrong value
    By bk77 in forum Excel General
    Replies: 4
    Last Post: 03-25-2009, 02:17 PM

Tags for this Thread

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