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
Bookmarks