Monday, November 26, 2012

How to Compare Two Columns in VLookup


1. Open Excel 2010 and select a workbook. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.
2. Sort the values that will be included in the vlookup. The first column needs to sort in ascending order. Click in the first cell of the third column. Click the 'Formulas' tab and select the 'Lookup Reference' button. Select 'Vlookup' from the list of functions. The function arguments window opens.
3. Click the 'Lookup value' field. Click the red arrow. Select the first cell in the third row. Click the 'Table Array' field. Click the 'Red Arrow.' Highlight the data in the two columns. Click the 'Column Index Number' field. Type '2.' Once the matched vlookup value is found, it will return the cell value in the 2nd column.
4. Type 'False' in the 'Range Lookup' field. False indicates an exact match while true will find a close enough match. Click 'OK.' Excel will compare the lookup value against the two columns in your spreadsheet and display the cell value in the second column if a match is found.

Blogger news