Use Vlookup in multiple columns at a time

माइक्रोसॉफ्ट एक्सेल में 30 कॉलम में एक साथ VLOOKUP FORMULA कैसे लगायें। 

वीडियो को देखने के लिए यहां क्लिक करें।

How to vlookup multiple columns in Excel – example

Here is the VLOOKUP formula we have:

=VLOOKUP(I2,A:F,{4,5,3},FALSE)

But you can’t just insert this formula into J2 cell and hit enter. This would only return one value. What you need to do is select a vertical array that corresponds to the number of columns in your VLOOKUP formula. In our case, we need to select three cells. After that, you can insert the formula to the formula bar and press Ctrl+Shift+Enter for Windows (Command+Return for Mac) – this will apply an array formula in Excel.

Excel Online vlookup to return multiple columns 

In Excel Online, VLOOKUP works almost the same way, but you don’t have to select an array and press the combination of buttons to implement it.

You can just insert the formula in one cell and press Enter => the matching values for the columns specified in the formula will be populated automatically.

 

Click on below link to download excel file format:

}

Thank you