+ Reply to Thread
Results 1 to 3 of 3

Index Match Required

  1. #1
    Registered User
    Join Date
    01-21-2019
    Location
    Melbourne
    MS-Off Ver
    2016
    Posts
    2

    Index Match Required

    Hi,

    I need help with the attached excel function.

    I want to be able to type in a function into the yellow highlighted cell which says "Excel Function needed here".

    I want to match the cells B5,A5, and B20 from 'Data' Sheet to Columns B,C,D from 'Data2' Sheet to get the 'Price' column from 'Data 2' to show in 'Data.

    Let me know if this is not clear enough. I have highlighted in yellow everything that is needed i think.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Index Match Required

    Hello,

    try in cell K5

    =INDEX('Data 2'!$M$1:$M$100,MATCH(Data!$B$20&Data!A5&Data!B5,INDEX('Data 2'!$B$1:$B$100&'Data 2'!$C$1:$C$100&'Data 2'!$D$1:$D$100,0),0))

    Adjust the row references to suit the data in Data 2. Don't use that formula with whole columns, because it will be really slow.

    Copy down.

  3. #3
    Registered User
    Join Date
    01-21-2019
    Location
    Melbourne
    MS-Off Ver
    2016
    Posts
    2

    Re: Index Match Required

    That worked great. Thanks

+ 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. Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. Required Index Match with If function
    By siroopm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-29-2016, 04:54 AM
  3. [SOLVED] Index & Match help required
    By DeeEmmEss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 06:23 AM
  4. [SOLVED] Help required with match and index functions
    By frosty_1977 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-11-2015, 06:01 PM
  5. [SOLVED] Formula required (Index, Match)
    By nagesh.tvsr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2014, 01:30 AM
  6. Index Match only 4 results required
    By pepe.r.taylor in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-31-2011, 11:28 PM
  7. Excel 2007 : INDEX/MATCH help required
    By 5foot9 in forum Excel General
    Replies: 1
    Last Post: 07-22-2011, 02:02 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