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
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com