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

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

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