Hi.

I have a list of Countries, and for each COuntry, I have some items. There
are many entires for each Country. What I'm trying to do is have 2 drop down
boxes - one for the Country, and then on for the items listed for that
country. I merely want to populate the COuntry cell with the name of the
country from the COuntry drop down, and populate the item cell with an item
selected for that selected country. Now I've tried the solution shown in the
Excel Hacks book, but the itesm part of the solution continues to give me an
error in the folowing formula:

=OFFSET(INDIRECT(ADDRESS(MATCH(Val1Cell,Country,0) +1,2,,,"Lists")),0,0,COUNTIF(Country,Val1Cell),1)

Any assistance is appreciated.

NWO.