Results 1 to 6 of 6

Help with Lookup/match/index with 2 criteria.

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2004
    MS-Off Ver
    2010
    Posts
    30

    Help with Lookup/match/index with 2 criteria.

    \1

    I'm trying to do a lookup based on 2 criteria. 1 is a general column, and the other is a value to look up in that column. In the attached screenshot, cells B2:D4 would be a named range "ItemsFound" and cells A2:A4 would be a named range "ItemResults". I've used the next largest integer in the ItemsFound so I can use a match formula with a -1 to find the next smallest value. This way if it's somewhere in between my criteria it can still find it. I'm getting confused as to how to also base it on difficulty.

    I think a way to simplify the question would be how would I use a match function to lookup values in a single column of a larger array? My real data has 70+ columns to look through.
    Last edited by Fizziii; 04-28-2011 at 10:01 AM.

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