Situation
VLOOKUP is great for extracting information from a huge data table based on what you are looking for. But what if you need to extract more than one column of information? For eg. Lets say you have salesperson’s name in left most column, and monthly sales figures in next columns, one for each month. Now, you want to find the total sales made by a given sales person. How do you go about it?
Data:
![Data for this Example -Get Multiple Outputs [VLOOKUP Quick Tip]](https://chandoo.org/img/f/vw/vloookup-from-multiple-columns-data.png)
Solution
Simple. You can use an array in the column number field of VLOOKUP. So for eg. =SUM(VLOOKUP(value, list, {2,3,4},false)) will give you sum of values in columns 2,3 and 4. Of course you must press CTRL+SHIFT+Enter after typing the formula. See few more examples:
Examples:
![Data for this Example -Get Multiple Outputs [VLOOKUP Quick Tip]](https://chandoo.org/img/f/vw/vlookup-multi-column-examples.png)
Sample File
Download Example File – Get Multiple Outputs [VLOOKUP Quick Tip]
Special Thanks to
John for the tip. (Click on the name to see tip)
Similar Tips
One Response to “How to export YouTube video comments to Excel file? – Free template + Power Query case study”
And I asked myself when i saw your Accouncement Video for the Give away: "Seriously, will Chandoo go manualy thru all his Videos and pick the winners?!". Great connection to the give away with this tutorial 🙂 !