How to Return Multiple Values in Excel Lookup Function | All Matches Results
Vložit
- čas přidán 9. 09. 2024
- In this Excel video tutorial, we gonna see How to Return Multiple Values in Excel Lookup Function by returnin all the matches for a lookup value. Return several results with lookup in Excel.
The Lookup functions in Excel, such as Vlookup, Xlookup, Hlookup, Index Match and so forth, are one of the best functions in Excel and one of the main functions in Excel too, because lookup is a formula to automate tasks in Excel and also to automate repetitive processes with Excel.
Lookup is a search function. Instead of you searching for what you need, lookup formula searches for you.
Vlookup means vertical search or vertical search. Hlookup means horizontal.
We can use all those formula mentioned above.
For example, let's say you have an Excel table with sales for the entire year. in the first column you have the sales date and in the next column you have the sales corresponding to the date.
To know how much you sold on a specific date, you don't need to look for this information in your database or in your Excel table, you can simply tell the Vlookup function to look for the date you want and the Vlookup function will find it. that date and return how much you sold on that specific date.
Therefore, the Vlookup Excel function is excellent for everyday life and the job market, as it can automate repetitive tasks.
#JopaExcel #Dashboard #Excel
Of course, we can also use other functions, such as FILTER. =FILTER(D:D, C:C=M3)
But, not all versions of Excel have the Filter function, so using the LOOKUPs functions is still a good dynamic solution.
Very powerful and useful technique 👌and a good alternative for those who cannot use the filter function
Absolutely! Not everyone has the most recent versions of Excel, so LOOKUP functions remains an excellent options. 🙏👍
How to with value of amount