When we search for data on excel**, the first thing that comes to mind is the vlookup function, which is also the most proficient lookup function used by friends, but the vlookup formula alone can only find 1 column of data, if you want to solve the problem of finding multiple columns of data at the same time, friends feel that vlookup is not good. In fact, we only need to simply change the vlookup formula, and we don't need to nest other functions, so we can easily find multiple columns of data at the same time. For example, we need to extract the amount-related data from this detailed item schedule (Figure 1). 
Step 1: We select all the C8 to E8 cells of the line of item A that we are looking for (Figure 2). 
Step 2: Enter the formula, directly enter the equal sign, and then enter the vlookup function, the first parameter of the function, is the b8 cell where the item a is found, the second parameter, the original ** region, after selecting the region, don't forget to press the f4 key to turn the region into an absolute reference, the third parameter, the multiple columns that need to be found, this is to use the array, first enter the curly braces, and then, in the curly brackets, the budget amount, the actual allocation amount, and the number of columns where the reduction amount is located, enter them respectively, That is, the number of columns of 3, 6, and 7, the last parameter, select the exact match, complete the closing bracket, and the formula is entered (Figure 3). 
Step 3: Since it is an array formula, you can't press the "Enter" key directly when confirming the formula, you need to press "Ctrl +Shift+Enter" to find out the data involved in Project A (Figure 4). 
Step 4: Place the mouse in the lower right corner of cell E8, when the number mark becomes "cross", double-click to fill it, and the data of other items in ** will also be found (Figure 5). 
Publish a collection of dragon cards to share millions of cash
This simple method of multi-column search, solves the problem of friends who will only find the vlookup function, and the confusion when searching for multi-column data, I hope it can help friends, if this method helps you, please like and support it, follow me, and continue to share practical office operation skills.