How to use excel's vlookup to match multiple columns of data at once

How to use excel's vlookup to match multiple columns of data at once: first open the data table you want to find; then click the mouse to select the G2 cell to match, and enter the VLOOKUP function [[=VLOOKUP($F2,$ a2:$D7, column (B1), 0)]]; Finally, select the exact search and drag and drop the function.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to use excel's vlookup to match multiple columns of data at once:

1. First, open the data table you want to find, as shown in the figure. We need to match the job quantity, performance and salary in Table 1 and Table 2.

#2. Click the mouse to select the G2 cell to be matched.

3. Enter the VLOOKUP function [=VLOOKUP($F2, $a2:$D7, column (B1), 0)].

#4. Select the exact search and drag and drop the function to complete the search return of multiple columns.

Related learning recommendations: excel tutorial

The above is the detailed content of How to use excel's vlookup to match multiple columns of data at once. For more information, please follow other related articles on the PHP Chinese website!