Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
I have a parts list with part names, descriptions and prices in Excel. I
would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
I would suggest a DV dropdown List with a combobox assist.
http://www.contextures.on.ca/xlDataVal10.html Then VLOOKUP formulas to return the descriptions and prices. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Sat, 20 Oct 2007 08:25:00 -0700, Vince R wrote: I have a parts list with part names, descriptions and prices in Excel. I would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
Thank you. I have successfully implemented your suggestion on the parts list
and it is a huge improvement. However I have to scroll through the drop down list to find the part ID I need. Is there a way I can get to the section of parts I am looking for in the drop down list by typing the first letter or two of the ID I am looking for? Thank you again. Vince R "Gord Dibben" wrote: I would suggest a DV dropdown List with a combobox assist. http://www.contextures.on.ca/xlDataVal10.html Then VLOOKUP formulas to return the descriptions and prices. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Sat, 20 Oct 2007 08:25:00 -0700, Vince R wrote: I have a parts list with part names, descriptions and prices in Excel. I would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
Vince
If you followed Debra's instructions on creating the DV list with ComboBox you should have Autocomplete in the partname list. Download her sample workbook from that site to see it in action. Gord On Sun, 21 Oct 2007 06:14:04 -0700, Vince R wrote: Thank you. I have successfully implemented your suggestion on the parts list and it is a huge improvement. However I have to scroll through the drop down list to find the part ID I need. Is there a way I can get to the section of parts I am looking for in the drop down list by typing the first letter or two of the ID I am looking for? Thank you again. Vince R "Gord Dibben" wrote: I would suggest a DV dropdown List with a combobox assist. http://www.contextures.on.ca/xlDataVal10.html Then VLOOKUP formulas to return the descriptions and prices. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Sat, 20 Oct 2007 08:25:00 -0700, Vince R wrote: I have a parts list with part names, descriptions and prices in Excel. I would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
Thanks again. I got it to work...very slick.
I would like to use this look up capability in a different worksheet (our bidding program) I get an error message saying data validation will not work with references from other workbooks or worksheets. I can probably figure out a way to work around this but it will be messy. Anyh suggestions? Many thanks again "Gord Dibben" wrote: Vince If you followed Debra's instructions on creating the DV list with ComboBox you should have Autocomplete in the partname list. Download her sample workbook from that site to see it in action. Gord On Sun, 21 Oct 2007 06:14:04 -0700, Vince R wrote: Thank you. I have successfully implemented your suggestion on the parts list and it is a huge improvement. However I have to scroll through the drop down list to find the part ID I need. Is there a way I can get to the section of parts I am looking for in the drop down list by typing the first letter or two of the ID I am looking for? Thank you again. Vince R "Gord Dibben" wrote: I would suggest a DV dropdown List with a combobox assist. http://www.contextures.on.ca/xlDataVal10.html Then VLOOKUP formulas to return the descriptions and prices. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Sat, 20 Oct 2007 08:25:00 -0700, Vince R wrote: I have a parts list with part names, descriptions and prices in Excel. I would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up an item by starting to type see possible choices
If you give the list range on the other sheet or workbook a defined name and use
that name in the DV source dialog you will be OK. In source dialog enter =MyRange where MyRange is your defined name. See Debra's site for more. http://www.contextures.on.ca/xlDataVal01.html#Name for sheet in same workbook http://www.contextures.on.ca/xlDataVal05.html for sheet in other workbook Gord On Sun, 21 Oct 2007 10:04:00 -0700, Vince R wrote: Thanks again. I got it to work...very slick. I would like to use this look up capability in a different worksheet (our bidding program) I get an error message saying data validation will not work with references from other workbooks or worksheets. I can probably figure out a way to work around this but it will be messy. Anyh suggestions? Many thanks again "Gord Dibben" wrote: Vince If you followed Debra's instructions on creating the DV list with ComboBox you should have Autocomplete in the partname list. Download her sample workbook from that site to see it in action. Gord On Sun, 21 Oct 2007 06:14:04 -0700, Vince R wrote: Thank you. I have successfully implemented your suggestion on the parts list and it is a huge improvement. However I have to scroll through the drop down list to find the part ID I need. Is there a way I can get to the section of parts I am looking for in the drop down list by typing the first letter or two of the ID I am looking for? Thank you again. Vince R "Gord Dibben" wrote: I would suggest a DV dropdown List with a combobox assist. http://www.contextures.on.ca/xlDataVal10.html Then VLOOKUP formulas to return the descriptions and prices. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Sat, 20 Oct 2007 08:25:00 -0700, Vince R wrote: I have a parts list with part names, descriptions and prices in Excel. I would like to retrive prices and descriptions for an order by starting to type the part name in a cell and have excell suggest possible parts based on the first letters of the name so I could click on the one I want. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Choices | Excel Worksheet Functions | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |