Drop down box
If I choose a word/command/field from the drop down box,
how can I format the next cell over recognize this selection and display a number? Basically I created a drop down box, Van, Bus, etc... When I choose Van, I would like the next cell over to recognize this selection and show $80. Many thanks and appreciate the help! Rob |
Drop down box
You could use something like Vlookup().
Check out Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Robert Albrecht" <Robert wrote in message ... If I choose a word/command/field from the drop down box, how can I format the next cell over recognize this selection and display a number? Basically I created a drop down box, Van, Bus, etc... When I choose Van, I would like the next cell over to recognize this selection and show $80. Many thanks and appreciate the help! Rob |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com