I know this is simple but I am struggling...I need to use a lookup function
to automatically display the product name (cell c5) and price (cell c6) in
the sales form when the product ID is entered.

Enter New Sales Information Below
Region
Product ID
Product Name
Product Price
Units Sold


Product Information
Product ID Product Name Product Price
CW China Wok 19.95
HBM Homeware Bread Machine 49.95
HBMD Homeware Bread Machine -Deluxe 89.95
HCD Homeware Casserole Dish 19.95
HCP Homeware Cookie Pan 9.95
HEW Homeware Electric Wok 29.95
HPP Homeware Pizza Pan 19.95
HR Homeware Rotisserie 119.95
OEG Olson Electric Grill 159.95
OGG Olson Gas Grill 159.95
SPP Stone Pizza Pan 29.95
WCM Wilson Coffee Machine 29.95

Total Sale