drop down auto fill two seperate cells from one drop down list

Hello all... I am by no means a computer guy, but I have learned a little bit in the short term that I have been messing with Excel. I have attached a spreadsheet that I need some help with if anyone can or has the time.

I figured out how to make a drop down list with some time on YouTube, but I am trying to figure out how to auto import the price of a unit after you select it into the first cell of the drop down list, I need to get the price to auto fill into the unit price column. I am sure that this is some super easy process, but I am just not excel smart yet...

any help would be greatly appreciated! I tried searching, but everything I found is way more complicated then what I am looking for. Most were about several drop down lists in one table etc.. not at all what I am hoping to accomplish.

Thanks again...
BigRut

Example to site.xlsx

Hi,

i have make the changes, please have a look.

retry Example to site.xlsx

Thanks for the attempt, but that is not quite what I was looking for...

When I select something from the drop down list in column A, I need the unit price to show up in column F. no other data needs to be generated.

Thanks again for your help!!!