ComboBox and multiple columns matching

[gemcgraw]

Per se.... ComboBox1 is set looking at columns A & B on Sheet1, with a boundColumn = 1; ColumnCount = 2. I am working with the situation where column A can have duplicates, but its corresponding Col-B is a different value. When the user drop-selects Room (Col-A) "119" with Printer (Col-B) "ABC" how can I make it look for and match both columns A & B from the ComboBox1 (ColumnCount-2) selection?