Hi Kerry,

Welcome to ExcelFox !!

You could try VLOOKUP function to accomplish this task.

If your dropdown value in A2,

In B2

=VLOOKUP(A2,Sheet2!$A$2:$B$10,2,0)

where

Sheet2!A2:B10 holds the Description (Col A) and Price (Col B)

Post back if any query.