I have 2 columns in sheet 1. Column A contains associate names, and column B contains their ID#'s. I have a userform with 2 comboboxes, one for names and one for ID's. I would like to be able to select either box and have the other autoselect the corresponding information. Currently, I have it working if I select something out of the first box by using a vlookup command. However, I cannot figure out how to do the 2nd box. I have tried a match function, but couldn't get it to work consistently.