Yes- you could create a list (table) in some other sheet, then use a formula
like
=INDEX(range containing prices, MATCH(range that contains the WORDS,the cell
where you typed in PSL ...,0))
"wandering" wrote in message
...
I want to associate typed words and monetary values so that I don't have
to
continually retype the price. Is there a table that I can set up that a
template or document draws from?? An example would be that everytime I
type:
PSL 3.5 x 9.5 it would bring up $9.25 into a specific field for further
computation.
|