Results 1 to 5 of 5

Lookup OR Index/Match with multiple Array's

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    12

    Lookup OR Index/Match with multiple Array's

    Dear All,

    I'm facing another problem within my worksheet, Below I made a similiar example of what I try to acquire...
    I need to lookup for EACH year the results if a system (dropdown list in cell B28) is OK or NOT OK, but it also needs to look at what site (Dropdown list in cell C28 )

    I tried initially with VLOOKUP($B$28;$B$4:$Q$4;2)...VLOOKUP($B$28;$B$4:$Q$4;3)...VLOOKUP($B$28;$B$4:$Q$4;4)...
    and this works, but only for one array and one look up value at a time.

    Is there a way where I can use INDEX/MATCH or CHOOSE to work with the 2 values to look up at?

    Thanks in Advance
    Numnum
    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. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  2. LOOKUP with Multiple Criteria (ARRAY INDEX and MATCH)
    By snowktt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2014, 02:24 AM
  3. Lookup, Index, Match, Array Help
    By Reaye in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2013, 03:36 PM
  4. Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  5. table, index, array, match, lookup?
    By spxer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2006, 04:35 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