Results 1 to 14 of 14

Index Match on two columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    40

    Index Match on two columns

    I've attached an example of what I am trying to do. Currently the orange formula brings in the building number of the first building that matches the criteria of the days out. I want to find the building that matches the days out and the commander. I've tried two formulas one in yellow and one in pink. I'm not able to make either work. Can you see my error?
    Attached Files Attached Files
    Last edited by Huddle; 06-09-2011 at 03:16 PM.

Thread Information

Users Browsing this Thread

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

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