generate a menu list

[Guest]

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?

 

[Guest]

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

---