Results 1 to 10 of 10

Index Lookup 2 Criteria with Few Strings Can be Match with Any Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    34

    Index Lookup 2 Criteria with Few Strings Can be Match with Any Criteria

    Hi all good people!

    Screen Shot 2021-02-23 at 15.15.11.png

    I need to lookup 2 criteria using Index and Match but I need one string, for example "apple" (see the image/file attachment) will result in the desired string "FRUIT 1" if the second criteria match any string, while the other string "orange" will result in the desired string "FRUIT 2" or "FRUIT 3" if the second criteria match specific string as shown in the Dimension Table.


    Hope anyone here can help me.
    Thank you..
    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. Lookup Multiple Criteria using Index-Match in VBA
    By ykobure in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2015, 01:41 AM
  2. Lookup with criteria / Index match (?) / Using dates
    By RenanCip in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-28-2014, 11:23 AM
  3. [SOLVED] index lookup problem against 2 criteria (match)
    By Heinrich Venter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2014, 09:41 AM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. Multiple Criteria Index/Match Function in VBA Looking Up Dates/Strings/Numbers
    By nadstradamus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 12:35 PM
  6. Help with Lookup/match/index with 2 criteria.
    By Fizziii in forum Excel General
    Replies: 5
    Last Post: 04-28-2011, 10:00 AM
  7. Lookup Or Index, Match then Sum with several criteria.
    By borissinga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2010, 08:31 AM

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