Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box
Look at VLOOKUP with a table containing Van, Bus etc with corresponding values
=VLOOKUP("box value",Sheets2!A;B,2,0) where Sheets contains the table in columns A& B. "box value" is Bus, Van etc HTH "Robert Albrecht" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box
Hi Robert,
your drop down box should refers to a cell, lets say H1 for eg. create an auxiliar ID column in your table i.é. A B C 1 ID Type $$ 2 1 van $80 3 2 xxx xxx 4 3 xxx xxx use a formula =vlookup(h1,a2:c4,3,false) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Robert Albrecht" escreveu: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box
I'm still having trouble.
This is for cell B7 in New Client Quotes sheet = VLOOKUP('Vehicle Pricing Guide'!A3:A14,'Vehicle Pricing Guide'!A3:B13,2,0) This is the formula I found. It gives me a number from the B column of the other sheet (Vehicle Pricing Guide), which is what I want, but doesn't change when I change the text in the drop down box. How do I make the number in B7 of New Client Quotes sheet change correspondingly when I change the text in the drop down box of A7 of New CLient Quotes sheet? -Rob "Toppers" wrote: Look at VLOOKUP with a table containing Van, Bus etc with corresponding values =VLOOKUP("box value",Sheets2!A;B,2,0) where Sheets contains the table in columns A& B. "box value" is Bus, Van etc HTH "Robert Albrecht" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box
in B7:
=VLOOKUP('New Client Quotes'!A7,'Vehicle Pricing Guide'!A3:B13,2,0) "Robert Albrecht" wrote: I'm still having trouble. This is for cell B7 in New Client Quotes sheet = VLOOKUP('Vehicle Pricing Guide'!A3:A14,'Vehicle Pricing Guide'!A3:B13,2,0) This is the formula I found. It gives me a number from the B column of the other sheet (Vehicle Pricing Guide), which is what I want, but doesn't change when I change the text in the drop down box. How do I make the number in B7 of New Client Quotes sheet change correspondingly when I change the text in the drop down box of A7 of New CLient Quotes sheet? -Rob "Toppers" wrote: Look at VLOOKUP with a table containing Van, Bus etc with corresponding values =VLOOKUP("box value",Sheets2!A;B,2,0) where Sheets contains the table in columns A& B. "box value" is Bus, Van etc HTH "Robert Albrecht" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down then populate | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
drop down box leading to another drop down box | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions |