Hi Luka

You need to take a look at the VLOOKUP function. You will find an easy
explanation at Debra Dalgleish's site
http://www.contextures.com/xlFunctions02.html

--
Regards
Roger Govier
"luka" wrote in message
...
For business purposes. I would like to put an item or model # in one cell
and
have the price for this particular item automatically populate the cell to
it's right. because each sale could be different I want to the form to
populate the unit price for any item that I input in a particular cell

Hope this makes sense

Thanks