I want to select a drop down list item and have it display a unit price in a diff cell

Hi Paul, welcome to the forum

there is nothing magical about a drop down (Data Validation). It is exactly the same as if you had typed the entry in manually, the only differences being that a DD can save you some typing, help avoid typos and help restrict entry to only a specified "list". Other than that, there is basically no difference. You would refer to it in formulas etc the exact same way as if you were referencing a manually entered cell

So, based on that, as suggested, you could use a simple vlookup to pull the values from that table you mentioned.

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.