I want to create a simple invoicing from a list of table. Like what I have
below:

A B C
D
Date Item (list table) Unit Price (should be automatic) Manually
entered

How to defined a function in Column C if I select a particular item in the
list table, it displayed its corresponding unit price.

Your help is greatly appreciated.

Thanks.