Turns out that for my requirements your suggestion of the Index / Match works
much better than the LookUp functions. Thanks very much!!

"Dave R." wrote:

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.