Need help with these

Insert a function to lookup the Product# and return the Description for each product. (Remember to use absolute cell referencing where required)

Insert a function to lookup the Product# and return the Unit Price for each product. (Remember to use absolute cell referencing where required)

Insert a formula to calculate the Amount for each product

Insert a function to calculate the Invoice Subtotal

M21 X V fx A B C D F F 8 Bill To: G H 9 10 Tax Amount 15% 11 12 Phone: 13 Email: 14 15 Quantity Product# Product Name Description Unit Price Amount 16 21 11 Dunks Bits Dough to make the Bits $10.00 17 21 12 coffee Coffee powder to drink $5.00 18 21 13 suger Suger to put in drinks $3.00 Invoice Subtotal 19 Tax Amount 20 If you have any questions concerning this invoice, please contact me at the email above. Shipping Fee 21 Thank you for your business! Invoice Total 22 Monthly Payment 23 24 Invoice Template Inventory Customer List + EER Ready 26C 60924 O 9 * W Type here to search