We’re going to be looking for something, so include a spare cell to use for “searching”. Select some cells where you want the result of your calculation (the VLOOKUP function) to go. In the following, you’ll find my approach to creating a VLOOKUP which has been fine-tuned over several years and for me is the easiest and fastest solution. There are several ways of doing this, with some being more complicated (and effective) than others. If you don’t want to start over after several months of hard work in a workbook – do get the structure of your calculations and data right from the beginning. It can be revived, but usually, it’s easiest to start over. I find that this usually ends in “spreadsheet mayhem” (not good!) and is ultimately the cause of death for the workbook.īecause the calculations and data storage get mixed up. Most people just put formulas into random cells.
