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

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

Comments

New Comment

NOTE: (Put code blocks in [[[ and ]]] markup to be formatted.)

(Posted comments will be checked by the administrator before being published)



PrivacyCookies