Returning the price of an item

[Randell Gower]

I need to have Excel return the price of an item when I enter it. I work
with lists and I frequently type in an item and then I manually enter a
price for the item. The cost of the item is known, I just have to look it
up in a book and then manually type in the price.

Is there a way to create a table, using two columns, one with the item
description, one with the price I want returned in my spreadsheet? That way
I make only one entry and the computer returns the proper price for me.

Thanks,
Randy