Sorry for the double reply... when I sent the post, it said it didn't work so
that's why I did it twice :)

"TonyK" wrote:

I have a spreadsheet where I have a Specialty Name stored in A2 (source is a
named range) via a drop down list. In B2 I have a Clinic Type which I need
to display entried dependant on the entry in A2. I can get the first Clinic
Type list to display correctly by using the formaula "=INDIRECT(A2)" in the
source box of the data validation dialogue box. Howeveer I need to extend
the Clinic Types to span columns C through AZ. What should the formula be?
Look forward to hearing from anyone who can help.
Kind regards
TonyK