Getting Excel to Auto-populate a price in a cell, based on text in another cell

I have an Excel file for tracking purchase orders. I created a drop-down list in Cell D so I can pick the item that is being ordered (Description). Is there any way to have the next cell (Unit Price) auto-populate with the price that goes with that description?

So if I put:

"Foam Core White Single" in cell D1, Cell H1 will automatically populate with "$28" but if I put "Foam Core White Box" it will automatically populate with a different amount.

I tried using IF statements but they don't seem to work. I might be making a mistake in the formula but I also think there might be too much wording. Is what I'm trying to do possible? It would be very helpful to have it auto-populate instead of going back to look at the price sheet constantly.

IF function is not suitable for price lookups as you need to handle every available item. Best option is to have a table with items description and prices and then use VLOOKUP or combo of INDEX and MATCH functions.

Formula:

Please Login or Register  to view this content.

But to give you better help it would be useful to have an example file, please loop at the yellow banner at the top of the screen how to create and upload an example file. .

Thank you both! I will try this I'd rather not upload the file as it's a document for work. I'll watch the tutorials and figure this stuff out, I'm just glad I have a direction to go now!