How to vlookup to return multiple columns from Excel table?

In Excel worksheet, you can apply the Vlookup function to return the matching value from one column. But, sometimes, you may need to extract matched values from multiple columns as following screenshot shown. How could you get the corresponding values at the same time from multiple columns by using the Vlookup function?

Vlookup to return matching values from multiple columns with array formula

Vlookup to return matching values from multiple columns with array formula

Here, I will introduce the Vlookup function to return matched values from multiple columns, please do as this:

1. Select the cells where you want to put the matching values from multiple columns, see screenshot:

2. Then enter this formula: =VLOOKUP(G2,A1:E13,{2,4,5},FALSE) into the formula bar, and then press Ctrl + Shift + Enter keys together, and the matching values form multiple columns have been extracted at once, see screenshot:

Note: In the above formula, G2 is the criteria that you want to return values based on, A1:E13 is the table range you want to vlookup from, the number 2, 4, 5 are the column numbers which you want to return values from.