Pairings based on Division

Hey Guys-

I did some searching but couldn't find anything relevant enough (or lacked the effective query) to solve my problem. I am a tournament director for a random draw doubles league on a weekly basis- playing disc golf. Typically the way we pair teams is by drawing names out of four containers that are based on division, those divisions being Professional, Advanced, Intermediate, and Recreational. Pro is the highest skill level and Rec is the lowest, so ideally we pair Pros with Rec players first and then move to pairing Adv with Int, and we do so until we run out of players in any given group and move to the next logical one. (If we run out of rec players some Pros play with Int, or if we run out of Pros, Adv players are paired with Rec. and so on...) I would love to have a more fluid way of pairing teams, as it currently takes anywhere from 20-30 minutes to pair teams given a pool of 50 players. I know there must be some way to set up a spreadsheet to more effectively solve my enigma, and I am decently versed in Excel, but totally stumped here.

Any thoughts?

Great start, but by pairing the 1's,2's,3's,etc I am left with pairing Pro's with 3 Int players and eventually there will be one Adv player on his own (which is fine, he plays California doubles for the round) So as soon as I run out of Rec players the numbers wouldn't match. I am more interested in possibly using an IF function somewhere to auto generate teams based on division (I guess?) Some logical test that would look for Pro's to go with Rec's and act accordingly when one division runs out of players and move to the next. The Rankings and random numbers being generated would probably have to be a part of this process I assume, but it's the pairings themselves that seems to be over my head-