Vlookup - Creating Schedule for Non-Profit Event

[jtmclean]

Hi,

We are trying to create a schedule for our big annual outreach event our non-profit does each year. I am trying to do vlookup which returns data on our judges. However, judges will be judging multiple teams at the same time. For example, judge group 7 will be judging teams 8 & 9. How do I return that result in one cell from vlookup? Thanks for any help you can offer. :




Team Judge Group Event Proctor
Team 1 1 Performance Proctor A
Team 2 2 Performance Proctor B
Team 3 3 Performance Proctor C
Team 4 4 Performance Proctor D
J6 5 Action Roundtable Proctor E
Team 6 6 Exhibit Proctor G
Team 7 6 Exhibit Proctor G
Team 8 7 Exhibit Proctor H
Team 9 7 Exhibit Proctor H
Team 10 8 Exhibit Proctor I
Team 11 8 Exhibit Proctor I

 

[Robert Mika]

It would get harder if you had more than two group for one judge so see this topic:

http://www.mrexcel.com/forum/showthread.php?t=614246
You can return multiple values from the same lookup

 

[jtmclean]

Thanks Robert. I came across this fix late last night and it seems to be working (and similar to what you linked me to): http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/