TundraSteve,Not exactly, my main issue is to find the index value of the specific formattedvalue in the listbox. here is an example which hopefully will better explain:DD1 - US, China, etc.DD2 - Job1, Job2, etc.Listbox - 1 | USJob12 | USJob23 | ChinaJob14 | ChinaJob2By using the top two dropdowns, c...