How to use the vlookup function in Excel 2013?

  
In Excel, the vlookup function can reference the values ​​of other table areas on any cell. It is very frequently used in Office. Today, the system home Xiaobian will introduce you how to use the vlookup function in Excel 2013. 1. If you want to reference the first value of the value 2.vlookup function in the corresponding number 1 column, select the "C” cell. Enter the “,” number to go to the next step; 3. Frame the area where the value to be referenced is located. Enter the “,” number to go to the next step; 4. Indicate that the value to be referenced is in the second column of the specified area, so enter “2” to continue the comma. 5. Enter "ldquo;0”" to indicate an exact search. Of course, we need to find it accurately. If you don't type it, Excel will default to “1”, which gives an approximation, which can sometimes cause trouble. 6. After returning, get the result! Will it be used? Will not continue to watch. 7. For example, I am now looking for a value corresponding to the number 2 of columns. Then I just change the number of columns in the value to “3”, telling it in column 3. 8. This will get the result! Is there a wood that is easy? - Microsoft Office 2013 (Professional Plus) Simplified Chinese version download: http://www.xp85.com/html/Office2013.html- System Home latest WinXP system, Win7 system download: http://www.xp85.com /html/list-104.html
Copyright © Windows knowledge All Rights Reserved