+ Reply to Thread
Results 1 to 5 of 5

Multi level match function

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    21

    Multi level match function

    Hello guys,

    Just need a quick one. Been trying to figure out whats wrong with my formula. The 4th column doesn't seem to produce the intended result.
    I have attached here for reference.

    Hope any experts can kindly help me on this.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by drean03; 11-19-2009 at 07:56 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Multi level match function

    would it not be easier (given your output table mirrors input) to just use

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-18-2009
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Multi level match function

    Hey Donkey. Man, that's pretty quick. Thanks a lot.
    Sorry for the erroneous double post though.

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

    Re: Multi level match function

    Try this change

    Please Login or Register  to view this content.
    Your last MATCH was using the * multiply instead of the + add, and you were also overshooting the goal by one, thus the -1 for the last MATCH.

    does that help?

  5. #5
    Registered User
    Join Date
    11-18-2009
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Multi level match function

    That did it too! Thanks a lot guys for all the help here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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