I have an invoice form in which I would like to automatically insert the
price based on the item selection in another cell. My data is a small table,
2 columns one for item, one for price. On my invoice for, I am able to
select my item from a drop down box, now I would like to automatically fill
the price column based on the item selection. What formula or function do I
need to use.