I am trying to create a drop down menu that will go to the specific
cell where that same text is in a worksheet when that text is selected
from the dropdown menu(combobox). I made a combobox menu from the
Forms menu not the Control. The text I am trying to find with this
macro is a list of countries in column B that starts row 2. In
Columns C,D, E there are surcharges that start in row 2 and continue a
number of rows down depending on the country. This format repeats
itself for some 146 countries on down the spreadsheet in terms of
rows. Is there a formula that can jump to or go to each country's
cell location on the spread sheet from the dropdown menu so the user
doesn't have to scroll through 2000 rows to find the right country?
e.g. Brazil is B2, Paraguay-B24, Venezuela-B46. Thanks.

Matty