View Single Post
  #6   Report Post  
Gord Dibben
 
Posts: n/a
Default

And combine the VLOOKUP with Data Validation drop-down list for easy entry of
the associated words so's you don't have to type PSL 3.5 x 9.5

See Debra Dalgelish's site for more on DV.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Thu, 6 Jan 2005 21:04:06 -0000, "Ken Wright"
wrote:

Take a look at VLOOKUP. You create a table with all the matching values and
then use the VLOOKUP formula where you want the prices to appear.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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.