How To Use Vlookup With An Excel Spreadsheet 10 Steps
If you haven’t yet created your document, open Excel, click Blank workbook (Windows only), and enter your data by column. If your data is organized by rows instead, you’ll won’t be able to use VLOOKUP to find a value. Lookup Value - The cell across from which the data that you want to look up is in. For example, if you want to look up data in cell F3, your lookup value will be in the third row of the spreadsheet....