View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

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.