I need some help to create a table that when I enter some words of a product
item in my list, it drops down a box and selects the matching items initial
letters highlighted and selects the correct sales value after I choose the
product. I don't know what you call this but I need some help to start off
please.

When I type in ADSL for eg, a list pops up with all matching ADSL matches in
the Products Column and in the Sales Column the actual price when selected
using the keyboard mostly. I will need to add some new products also with
their sale values and be able to copy the products text for copy/paste
elsewhere. Everything else I can manage with easily like sum total, printing
areas... just setting this thing up.

Help much appreciated. Thank you.

The data is this:

Titles of columns -
Ph # | Ref # | Products | P/Code | Manual Data (MD) | Sales $ | Comments.

Products data -
ADSL 1 ($100)
ADSL 2 ($150)
ADSL 3 ($200)
DUN... ($50)

Sales $ data -
$100
$150
$200
$50

eg.
DUN = $50
ADSL 2 = $150

Will look like this:
Column: Ph # | Ref # | Products | P/Code | Manual Data (MD) | Sales $ |
Comments.
Data: 01234.. | 1234567 | DUN...($50) | 1234 | blah blah | $50 | blah blah