I have 3 columns which are towns: A,B & C
No having 4 vehicles each with a diff volume, so when I work in the coll of
town "A" I would like to see the diff vehicles and select one. To the right
of the 3 x town columns I make another 3 columns which will summarise my
selection.
Now when I select vehicle num 2 (=10CuM)in the column of town "A" I would
like the value of veh=2 (10) to written in column G. ( A=G, B=H & C=I ).
Do I use the "IF-command" or how do I get that "10" in column G once I have
made my selection in column=A?
Thank you

See Debra Dalgleish's site for creating dependent data validation list
dropdowns.

http://www.contextures.on.ca/xlDataVal02.html

See her site also for VLOOKUP assistance to pull data to column G

http://www.contextures.on.ca/xlFunctions02.html

Note the downloadable sample workbooks.


Gord Dibben MS Excel MVP

On Wed, 1 Oct 2008 04:32:00 -0700, Blue Train <Blue
wrote:

I have 3 columns which are towns: A,B & C
No having 4 vehicles each with a diff volume, so when I work in the coll of
town "A" I would like to see the diff vehicles and select one. To the right
of the 3 x town columns I make another 3 columns which will summarise my
selection.
Now when I select vehicle num 2 (=10CuM)in the column of town "A" I would
like the value of veh=2 (10) to written in column G. ( A=G, B=H & C=I ).
Do I use the "IF-command" or how do I get that "10" in column G once I have
made my selection in column=A?
Thank you