Check out VLOOKUP in help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Grenville" wrote in message
...
Is it possible to automatically enter a numeric value (eg
a price) in a column by entering a code in an adjacent
column, referencing a list, in the same way as invoicing
software does?