Dear MSEXL Learner
Correcting a mistake won't be treated as hurting -: I am fully agree with u
but u can correct a mistake by polite way (Never create and suggest
formula's based on the articles you read in internet or book, understand the
concept how the functions are working and it's concept
Hi Mr. Shrinivas,
Correcting a mistake won't be treated as hurting and if you feel like that
then it's your way of thought and I don't want to comment about it. Real
experts never like to see wrong answers getting delivered to the questioners
and that was I did. If I am providing a wrong
Dear All
I am a member of this group for last more than 2 years.
I can proudly say that u will find the solutions(not solution) for all u r
problem.
By reading the above mail (from Noorani and Excel Learner) I got some
different feeling.So my suggestion is dont critise any one
Dont write any mail
Dear all,
I have tried to search about using vlookup with more than one condition.
Is their any one know a formula for that?
BRegards,
Haytham Zoromba
--
--
Some important links for excel users:
1. Follow us on
Dear Haytham,
Try SUMPRODUCT...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba haythamzoro...@gmail.comwrote:
Dear all,
I have tried to search about using vlookup with more than
Dear Haytham,
See sample...If Helps..
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV venkat1@gmail.com wrote:
Dear Haytham,
Try SUMPRODUCT...
*Best Regards,*
*Venkat *
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup with more than one condition
Dear Haytham,
See sample...If Helps..
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
Dear Haytham,
Please try below formula :
*=VLOOKUP(J3K3,$E$3:$H$3,4,0)*
*=VLOOKUP(VLOOKUP($J$3,$F$3:$G$8,2,0),$G$3:$H$8,2,0)*
other Alternative...
*=SUMPRODUCT((F3=J3)*(G3=K3)*H3)*
*{=INDEX($H$3:$H$8,MATCH(1,($F$3:$F$8=$J$3)*($G$3:$G$8=$K$3),0))}*
Hi Noorain Ansari,
It might be better if you might have constructed your example data with some
duplicates, since the questioner can able to understand the difference
between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs,
Dsum]*.
The *First set of formula's / Functions*
Dear Ms-Exl-Learner,
Thanks for your valuable suggestion..
Case -I, In case of duplicay all formulas are successfull working except
vlookup(vlookup) example.
You can see fresh attachement..
Case -II, You can't compare Sumproduct with If function both are
different..
Correct Syntex of Formula
Hi Noorain Ansari,
Case-1
I have attached the same file for your reference and I have not changed
anything on it just created a duplicate data.
Now look at the excel file and see what are all the results your formula is
deriving. Whether all the results are same? Take my previous mail and read
Dear MS.EXL.Learner,
Please see attached sheet...
**
Dear i better understand work and Concept of below mentioned
functionsi never denied to differencition between each
functions.
but at a time we can use a function for multiple purpose.
* *
I am tired...
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear MS.EXL.Learner,
Please see attached sheet...
**
Dear i better understand work and
13 matches
Mail list logo