mattglad6's channel

Using VLookUp to reference Invoice Items from a list.

Introduction to the VLookup function - using a Purchase Invoice as a worked example.

Using Simple Formatting to improve the appearance of the worksheet. Setting up Name Ranges to Allow Formulas to be entered in English.

Using If Statements to calculate an order amount. Where the price qouted is either each, per 100 or per 1000.