Results 1 to 9 of 9

Index and match

Threaded View

cyee Index and match 06-08-2021, 06:10 AM
JohnTopley Re: Index and match 06-08-2021, 06:24 AM
wk9128 Re: Index and match 06-08-2021, 06:28 AM
cyee Re: Index and match 06-10-2021, 01:50 AM
cyee Re: Index and match 06-08-2021, 07:24 AM
wk9128 Re: Index and match 06-10-2021, 03:16 AM
cyee Re: Index and match 06-10-2021, 04:10 AM
wk9128 Re: Index and match 06-11-2021, 09:35 AM
Liz C Re: Index and match 06-11-2021, 11:55 AM
  1. #1
    Forum Contributor
    Join Date
    09-02-2010
    Location
    singapore
    MS-Off Ver
    MS365
    Posts
    287

    Index and match

    Hi Guru,

    I trying to use Index and match for attached example but fail to show me the correct result.
    Can someone help?

    This is the formula i used.
    {=INDEX('sheet 1'!E2:G21, MATCH(1, ('sheet 2'!B2='sheet 1'!E2:E21) * ('sheet 2'!I1='sheet 1'!F2:F21), 0))}
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. [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
  4. 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
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. Replies: 3
    Last Post: 05-02-2013, 01:31 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