How to use multi-condition Vlookup function in Excel

In daily data processing, Excel's Vlookup function is often used to find data, but when multiple conditions are involved, its use becomes more complicated. PHP editor Apple will introduce you to the multi-condition usage of the Vlookup function to help you easily achieve multi-dimensional data search. Through this article, you will learn how to set up multiple conditions and how to use the Vlookup function to retrieve the required data if all conditions are met.

Take the following table as an example. We need to find the name and subject scores at the same time.

Insert an auxiliary column after the account, and then enter =A2&B2 in it. The purpose is to merge the contents of the two cells together.

Enter =VLOOKUP in the column to search for grades. Similarly, the first search object needs to be connected with the & symbol. The search range selects the auxiliary column and grade column just inserted. The output of the target column is 2 because of the grade. Listed in the second column of the search range, the final output is 0 to indicate an exact search. The final formula is: =VLOOKUP(F2&G2,C1:D7,2,0)

Finally press enter and double-click to fill in, and the results will be found.

The above is the detailed content of How to use multi-condition Vlookup function in Excel. For more information, please follow other related articles on the PHP Chinese website!