+ Reply to Thread
Results 1 to 3 of 3

index and match

  1. #1
    Forum Contributor
    Join Date
    12-01-2013
    Location
    Saudi
    MS-Off Ver
    Excel 2007
    Posts
    103

    index and match

    Need help I have four sheet and one master list im trying to figure out how can i combined this formula:
    =IFERROR(INDEX(CV[Column12],MATCH(D17,CV[Column5],0)),""),IFERROR(INDEX(AR[Column12],MATCH(D17,AR[Column5],0)),""),IFERROR(INDEX(EL[Column12],MATCH(D17,EL[Column5],0)),""),IFERROR(INDEX(ME[Column12],MATCH(D17,ME[Column5],0)),""))

    CV - Sheet 1
    AR - Sheet 2
    EL - Sheet 3
    ME - Sheet 4

    D17 is from Master List Sheet and I have table in every sheet.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: index and match

    Try

    =IFERROR(INDEX(CV[Column12],MATCH(D17,CV[Column5],0)),IFERROR(INDEX(AR[Column12],MATCH(D17,AR[Column5],0)),IFERROR(INDEX(EL[Column12],MATCH(D17,EL[Column5],0)),IFERROR(INDEX(ME[Column12],MATCH(D17,ME[Column5],0)),""))))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    12-01-2013
    Location
    Saudi
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: index and match

    thank you very much.. this perfect!

+ 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] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  2. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. [SOLVED] Index Match from a cell populated from index match
    By MarcLewis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2013, 05:30 AM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

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