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 Topics Pivot TablesAdvanced Topics MacrosAdvanced Topics VLOOKUPsFinal Steps
Excel training
Written: Mar-2024

Using VLOOKUPs

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

square

Also see

articles/Excel101square
PrivacyCookies