Hi Mark

Look in the Excel help for the Vlookup formula
Post back if you need more help


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mark Reynolds" <Mark wrote in message
...
Hi

I am new to excel and have a question regarding cells being filled with data
automatically

If I want to have a cell that contains a product, how do i get the cell next
to it to fill in the price automatically - I guess i am going to have to have
a set of prices allocated to a product somewhere in the sheet so it calls the
info in from this list?

Hope you kow what i mean

regards

mark