VLOOKUP lets you search for specific information in a Worksheet. For example, if you have a list of Product Codes with Prices, you could search for the Price or actual Item for a specific Code. It also lets you search between different Worksheets.
Its soooo easy when you know how!
- Highlight the range you want to analyse (on the OLD sheet) and name the Range. You will then have a range with absolute cell addresses ($ sign) in the formula. Makes copying easy as anything.
- Count the columns in the highlighted range before you do the formula.
- Go to the NEW sheet, click where you want the answer to be. Insert the VLookup formula.
- Complete as follows:-
- Now copy the Formula down. And Hey Presto! You have added the data from the OLD sheet, without you having to do a Find, Copy & Paste – through thousands of lines!
(If you already knew how to do this, please enter the Excel Microsoft Champ of South Africa Competition at #ExcelchampSA)