| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple drop down list validation
Hi All, I have two lists on one sheet, (Data), Services & Price. In another sheet, (Invoice), I am using a drop down list for services, and when a service is selected I would like it to automatically fill in the price column. I thought it would be simple but I seem to be getting the formula wrong, can you help? Many thanks! -- KerryOrr |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Simple drop down list validation
It always helps if you can give exact cell references where your data
is located, but in the absence of that it will be something like: =VLOOKUP(A1,Data!A$1:B$100,2,0) in B1 of your Invoice sheet. Assumes data occupies A1:B100 of Data sheet, and that your drop-down is in A1 of Invoice sheet, so adjust the references accordingly. Hope this helps. Pete On Oct 9, 10:55 am, KerryOrr wrote: Hi All, I have two lists on one sheet, (Data), Services & Price. In another sheet, (Invoice), I am using a drop down list for services, and when a service is selected I would like it to automatically fill in the price column. I thought it would be simple but I seem to be getting the formula wrong, can you help? Many thanks! -- KerryOrr |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Simple drop down list validation
Hi Pete, Many thanks for your reply, that's a great help! All working fine now. Very best wishes. Kerry Pete_UK;2412673 Wrote: It always helps if you can give exact cell references where your data is located, but in the absence of that it will be something like: =VLOOKUP(A1,Data!A$1:B$100,2,0) in B1 of your Invoice sheet. Assumes data occupies A1:B100 of Data sheet, and that your drop-down is in A1 of Invoice sheet, so adjust the references accordingly. Hope this helps. Pete On Oct 9, 10:55 am, KerryOrr wrote:- Hi All, I have two lists on one sheet, (Data), Services & Price. In another sheet, (Invoice), I am using a drop down list for services, and when a service is selected I would like it to automatically fill in the price column. I thought it would be simple but I seem to be getting the formula wrong, can you help? Many thanks! -- KerryOrr- -- KerryOrr |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Simple drop down list validation
Glad to be of help, Kerry - thanks for letting me know.
Pete On Oct 9, 8:45 pm, KerryOrr wrote: Hi Pete, Many thanks for your reply, that's a great help! All working fine now. Very best wishes. Kerry Pete_UK;2412673 Wrote: It always helps if you can give exact cell references where your data is located, but in the absence of that it will be something like: =VLOOKUP(A1,Data!A$1:B$100,2,0) in B1 of your Invoice sheet. Assumes data occupies A1:B100 of Data sheet, and that your drop-down is in A1 of Invoice sheet, so adjust the references accordingly. Hope this helps. Pete On Oct 9, 10:55 am, KerryOrr wrote:- Hi All, I have two lists on one sheet, (Data), Services & Price. In another sheet, (Invoice), I am using a drop down list for services, and when a service is selected I would like it to automatically fill in the price column. I thought it would be simple but I seem to be getting the formula wrong, can you help? Many thanks! -- KerryOrr- -- KerryOrr- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non VB (simple VB) Hyperlink Data Validation List | Excel Discussion (Misc queries) | |||
| question about creating a simple drop down list | Excel Worksheet Functions | |||
| validation list with drop down list of options?? | Excel Worksheet Functions | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
| How do I create a simple drop down box/List | Excel Discussion (Misc queries) | |||
Linear Mode
