Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
generate a menu list
Can I generate a key stroke that will input specific info.
as in: radial tire 18" whitewall vs. R1 It's for a catering business. I was hoping to help my friends with an XL document that could simply have them put in quantities, and then hit an item rather than have to type it. Also applies to pricing. Can that also be tied to the same? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
generate a menu list
Can I generate a key stroke that will input specific info.
as in: radial tire 18" whitewall vs. R1 One way is to use VLOOKUP or INDEX/MATCH in col B to lookup the input "R1" in say col A. Col B will then return "radial tire 18" whitewall" from the table_array Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rico" wrote: Can I generate a key stroke that will input specific info. as in: radial tire 18" whitewall vs. R1 It's for a catering business. I was hoping to help my friends with an XL document that could simply have them put in quantities, and then hit an item rather than have to type it. Also applies to pricing. Can that also be tied to the same? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) | |||
I don't have a List option in the Data menu | Excel Worksheet Functions | |||
How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
The 'Recently used file list' does not show up under the 'File' menu. | Excel Worksheet Functions | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |