+ Reply to Thread
Results 1 to 3 of 3

Trouble with Index/Match and/or Vlookup and mutliple column matching

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trouble with Index/Match and/or Vlookup and mutliple column matching

    I am using one spreadsheet (Rooms) to assign classes to rooms using class numbers. My intent is to find the rooms assigned and show the room information in the Classes spreadsheet using the class numbers in A2:A16 in the Classes spreadsheet. I have tried various VLOOKUP and INDEX / MATCH formulas but have never been able to successfully fully automate this process. I have put the Building Room name both to the left and right sides of my time period room assignments.

    The =VLOOKUP(A2,Rooms!$D$2:$H$32,5,FALSE) formula requires me to modify the col_index_num depending on which column the assigned class is located in.
    The =INDEX(Rooms!$A$1:$A$32,MATCH(A2,Rooms!$B$1:$B$32,0),1) solution I could only get to work for one column at a time.

    Is there a way to make this more useful and less manual? The workbook I am attaching contains the relevant two spreadsheets which are a small portion of my workbook that I use to do registration and class signups for a kite making conference.
    I am using Excel 2010 and also had the problem before that when I was using Excel 2003.

    Thanks in advance for any help.

    Bob Alford
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Trouble with Index/Match and/or Vlookup and mutliple column matching

    how do you decide which column you would use?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-19-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trouble with Index/Match and/or Vlookup and mutliple column matching

    When the class number in Rooms B2:G32 matches the class number in Classes A2:A16. All I am really trying to do is to show the Building room description in Classes B2:B15. The formulas in Classes C2:H16 are just my attempts to use Index / Match.

    Thanks for reading my post,
    Bob

+ 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