OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topic VLOOKUPsAdvanced Topics Pivot Tables
Excel training
First written: Feb-2024
last changed Mar-2024


The VLOOKUP vertical-lookup function allows you to look up data from a block of data on one part of your workbook, or in another workbook file on your PC or network, and return a cell from the found row.

This means you can look up things like prices from a price list, via a product code, and then use this on your spreadsheet.

I will leave you to investigate this yourself, but a starting point would be to search for Bing VLOOKUP or Google VLOOKUP, or just jump into one of many dummies guides such as https://spreadsheeto.com/vlookup