Hello;
My name is Mitul Parikh. I became new member on December 7.
PLEASE see below Excel worksheet attached.
I like to learn how to write IF FORMULA WITH NESTED VLOOKUP FUNCTION TO FIND OUT WHICH SALESPERSON Jamie, Javed OR Juno had
highest sales? , May be "AND" & "OR" OPERATORS WITHIN IF FORMULA MUST BE USED. I am willing to learn both of these operators.
THANK YOU VERY MUCH.
HAVE A NICE DAY.
Hi Mitul Parikh, welcome here at Mynda's Forum...
I think the purpose of these kinds of Forums is that you exchange the information on the Forum so others can learn from it and/or can contribute further steps. So I'm going to look at your file. I'll try to see if I can help and come back here to answer you. And not by e-mail, because nobody else can see it then and help you.
I hope you understand.
Frans
Hi Mitul
You can refer to https://www.myonlinetraininghub.com/vlookup-using-dates to learn more about VLOOKUP.
Sunny
Hi Mitul
According to you requirements, please refer to attahced solution using IF FORMULA WITH NESTED VLOOKUP FUNCTION.
Clark
Hi Mitul,
Clark's formula is an excellent demonstration of Excel's flexibility, and his formula writing prowess. However, as I explained to you via email when you asked the same question (which, BTW is naughty):
These aren’t questions you’d usually answer this way and they aren’t conventional questions you’d ask of a data set in a single cell.
I don’t think this is efficient formula writing. You would be better off creating a helper table that returns the values for the 3 salespeople in question and then use INDEX & MATCH to find the answer.
For now I don’t think answering these obscure questions is going to help you learn because they’re unlikely to ever come up in a real life situation. i.e. typically you want to know the top N items in a data set, you don’t pick some random people from a data set and then ask who made more sales etc. It’s just not typical and so learning how to solve an unlikely scenario is something you’re not going to or ever need to remember anyway.
So, don't stress yourself trying to understand Clark's complex array formula, instead take some time to learn and master the basics, because that's going to get you 90% off the way to where you want to be.
Mynda
Hi Mitul
I have to agree with what Mynda said above. You should learn the basics of VLOOKUP.
If you look at your file, the answers you gave in cells H12, H14 and H15 are all incorrect (and these are just the most basic of VLOOKUP)
If you think H12 is correct, then try changing cell G17 to Jessy (for example) and you will see the problem.
The answer you want in cell K13 is good for a challenge to your formula skills but almost unlikely to occur in the real world.
Sunny
I agree with them. Please don't try to understand my formula.my formula is made to meet all your requirements. It is not a real life case solution and just for your reference
