As we all know, Vlookup formula is used to lookup the value from the left most column. In advanced Vlookup function, we combine other functions for the improved outcome.
In this article, you will learn how you can use Vlookup to solve the problem in the advance way. This may even help you to create a dynamic dashboard.
Below is the image of Advance Vlookup (refer to Image 1).
In this Example, we have created helper column, defined the range name and on the basis of two lookup value we are getting the result.
Let’s understand from the start:-
We have data in which we have Customer name, product and quantity in the range A6:C15. In the other side, we have two drop down list: - first is customer name and second is product, so we want to retrieve the quantity as per the selection.
Follow below given steps:
Follow below given steps:
Follow below given steps:
Formula Explanation: =VLOOKUP(G6&G7,Data,4,0)
1) =VLOOKUP(G6&G7: This part of function will help to combine the Name and product for the lookup
2) Range1: This is our array for which we have defined the name
3) 4,0: Pickup column through lookup and 0 is define to pick the exact value
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
I am interested in Tip 2 to solve my problem. Col A has names and Titles in it. Ex [LName],[Title], [FName]. Titles repeat, one to many. In Column E, I wanted certain titles inserted; otherwise leave blank. Is there a VLOOKUP formula that will handle that? Many Thanks