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

I have a similar need with a project I am working on and I found this answer
using VLOOKUP. I have cited the person who posted the answer in another
thread.

"vlookup.Say your validation list returns your product in B2,and your pruduct
list is in c1:c50,with a price column next to it in d1:50.Your product list
is the same list that is the source for your drop down so the vlookup will
always be exact(a good thing for a price book)=vlookup( b2,C1:d50,2,false)
--
paul

remove nospam for email addy!"

This worked for what I needed to do. Hope this helps! Connie

PS You can find the thread I found by doing a search for DATA VALIDATION in
"Excel General Questions". Scroll down to the date 4/21/2006 (see the date
in the far right column). The title of the thread is "making prices appear
automatically when a value is selected" and there are 7 posts.


"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

I found a similar answer to what you are asking. Do a search for "Data
Validation" in "Excel General Questions" and scroll down to the date
4/21/2006. There is a post titled "making prices appear automatically when
a value is selected" and there are 7 posts. this helped me with my problem
and I think it's what you need too.

ConnieS

"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

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