Home >Topic List >vlookup matches two columns of data
vlookup matches two columns of data
The vlookup function is a function used in Excel to find and match data. It can be used to find a value in a range of data and return the corresponding value in another column associated with that value. PHP Chinese website has brought you relevant tutorials and articles. You are welcome to come and learn and read.
How does the vlookup function match two columns of data?The method for the vlookup function to match two columns of data: 1. Make sure that the two columns of data are located in two different areas, such as column A and column B; 2. In the cell where the result needs to be returned, enter the formula of the vlookup function, such as =VLOOKUP (A2, B:C, 2, FALSE), FALSE means an exact match, if you want an approximate match, you can change it to TRUE; 3. Press the Enter key to find and return the matching results.
Related coursesMore>
WEB front-end tutorial [HTML5+CSS3+JS]Elementary52484 plays
Little Turtle's zero-based introduction to learning Python video tutorialElementary500383 plays
Horse soldier spring video tutorialIntermediate85129 plays
Geek Academy mysql video tutorialAdvanced157868 plays
Related Resource DownloadsMore>