Tom, thank you for your response. I was able to *******ize your code to
get the end result I want but it is going to be very bulky when I get
it done. (I have pasted a small portion below.) The problem is, where
you see the names in the pasted selection, I have the same information
in a NameList on a hidden sheet. (BadgeList DNR in Column A, NameList
in Column B, etc., with all matching information in the same row)(I
hope I explained that correctly.)

If I could get cboOffNam to select the name to the right of the badge
number selected in cboOff I think the formula could be cut down
dramatically. (I have 3 Combo Boxes in each of 3 frames, and 25
officers to select from, so multiply the pasted code by 9 to apply to
each of the frames.) Also, when officer's badge numbers change or
employee's leave or new employee's get hired I will have to change the
code instead of just adding them into my dynamic range as I am
currently doing with a separate UserForm.
Again, thank you very much!

Private Sub cboOff_Change()
If cboOff.Value = "401" Then
cboOffNam.Value = "MELVIN, J.B."
ElseIf cboOff.Value = "402" Then
cboOffNam.Value = "LONG, G.A."
End If
End Sub
Private Sub cboOffNam_Change()
If cboOffNam.Value = "MELVIN, J.B." Then
cboOff.Value = "401"
ElseIf cboOffNam.Value = "LONG, G.A." Then
cboOff.Value = "402"
End If
End Sub

I am currently doing it on Sheet1 as a function where the DNR's are on
Sheet3 which is hidden. I enter the badge number in Sheet1!$A$2--like I
want to do in cboOff--and get the desired result in Sheet1!$A$3--like I
want to appear in cboOffNam

IF(A2="",NameList,INDEX(NameColumn,MATCH(A2,BadgeC olumn,0)))))