+ Reply to Thread
Results 1 to 3 of 3

Index, Match, If / And, Combo Box used in Conjunction??

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    Fenton, MO
    MS-Off Ver
    Excel 2010
    Posts
    7

    Index, Match, If / And, Combo Box used in Conjunction??

    T1B.xlsm

    So I have 2 problems that I'm trying to conquer within this spreadsheet. I'm not sure whether I'm headed down the right path or not, but I'll start with what I'm trying to do.

    1. On Sheet 'SAT 2' Column I44:I92, I have "Unassigned Machines" listed from Columns I5:K92 from the blanks in that grid area. What I need listed after each machine number in I44:I92 is what level of assignment is needed from either I3, J3, or K3. For example, I48 and I49 both show Machine # 38 which is correct as I have 2 vacancies. Therefore, I'd like for the first one to show 38 MM-7 and the 2nd one to show 38 MPE-9. Basically, I want all numbers listed to have either MM-7, MPE-9, or ET-10 listed behind them depending on the blanks that are needed to fill in.

    2. Columns J&K44:92 are merged, and I've created a Combo Box for that column. Based on what is needed to be assigned from Column I44:I92, I'll use the combo box in the adjacent column to the right and assign that vacant assignment to somebody. For example, in Merged Cell J/K44...I have assigned machine 32 to Lee, J. I would like for Lee, J to appear back up to the top of the sheet in Cell J5 (where I am assigning him the vacant spot) and populate his name to that vacant cell.

    I am completely stuck on this and cannot figure out what I am doing wrong.

    Thanks in advance for those of you that are way more advanced than me in Excel for your assistance.

    childs71

  2. #2
    Registered User
    Join Date
    08-24-2015
    Location
    Fenton, MO
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Index, Match, If / And, Combo Box used in Conjunction??

    I am open to any and all suggestions for either part of my problem.

  3. #3
    Registered User
    Join Date
    08-24-2015
    Location
    Fenton, MO
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Index, Match, If / And, Combo Box used in Conjunction??

    HELP!!! I'm Stuck!! Please!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index, Match, If, and Combo Box Working in Conjunction??
    By childs71 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-03-2015, 08:14 AM
  2. Vlookup in conjunction with Index and CountA function
    By manning457 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2015, 02:26 PM
  3. [SOLVED] Index Match into code when name is selected from combo box.
    By nancytaylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:57 PM
  4. Return a value with which combo of Lookup/Match/Index?
    By erickguz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2013, 04:27 AM
  5. Three Way Lookup Using Index Match Combo
    By nathanhamilton82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2012, 03:39 PM
  6. Lookup, Index, Match ... Not sure which combo will do it?
    By nikko4239 in forum Excel General
    Replies: 4
    Last Post: 06-08-2010, 06:32 PM
  7. Replies: 3
    Last Post: 07-11-2005, 02:05 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