Sounds like a VLOOKUP job. See the help.

"RickE" wrote:

Is there some way for me to type text in a cell, and that will generate a
price for that item inside another cell? This way I can just type my items in
my materials column, and it will automatically populate in my price column.

--
Thank you,

Rick