Thanks Niek

VLOOKUP will solve this and many future problems for Thanks Again



"Niek Otten" wrote:

Look at this tutorial:

http://www.contextures.com/xlFunctions02.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patricb" wrote in message ...
|i have a spreadsheet designed for invoicing, my staff enter products via
| validation lists, if the item selected is "wood" for example, can the cell
| next to it automatically enter the price into it. If it possible how can
| someone give me a simple example.
|
| thanks pat