drop down boxes and if then statements
 

How would I make a drop down box depentent on the selected informatio
of another drop down box and return a value to a third cel?

IE. state......City....Per diem amount

so you would select a city form the state drop down box, which woul
list the cities of that state in the city drop down box...afte
selecting the city it would return the per diem amount of said city t
another cel

--
Message posted from http://www.ExcelForum.com

drop down boxes and if then statements
 

Hi
as a starting point have a look at
http://www.contextures.com/xlDataVal02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Aversin " schrieb im
Newsbeitrag ...
How would I make a drop down box depentent on the selected
information
of another drop down box and return a value to a third cel?

IE. state......City....Per diem amount

so you would select a city form the state drop down box, which would
list the cities of that state in the city drop down box...after
selecting the city it would return the per diem amount of said city
to
another cell


---
Message posted from http://www.ExcelForum.com/

drop down boxes and if then statements
 

I have a sample workbook for dependent dropdowns. Mail me direct if you want
a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Aversin " wrote in message
...
How would I make a drop down box depentent on the selected information
of another drop down box and return a value to a third cel?

IE. state......City....Per diem amount

so you would select a city form the state drop down box, which would
list the cities of that state in the city drop down box...after
selecting the city it would return the per diem amount of said city to
another cell


---
Message posted from http://www.ExcelForum.com/