Retrieve VLOOKUP results based upon a conditional statement
Try this:
=SUMPRODUCT((A2:A100="Proposal")*(B2:B100="Jan")*( E2:E100))
where I have assumed your five columns of data are in A:E, and that
your data extends to row 100 - adjust as necessary.
Hope this helps.
Pete
On Jan 22, 12:50*am, Raphael
wrote:
Is it possible to embed a conditional statement inside of a VLOOKUP formula? *
For example, if I have the following data:
"Stage" * * * "Date" * * * *"Revenue" * * * * * *"Term" "WeightedValue"
Closed *Jan * * *$4,500,000 * * 3 * * * *$337,500
Verbal *Feb * * *$1,200,000 * * 1 * * * *$174,545
Proposal * * * *Mar * * *$973,800 * * * * * * * * * * * 3 * * * *$12,984
Proposal * * * *Mar * * *$2,300,000 * * 3 * * * *$30,667
Qualif *May * * *$1,000,000 * * 1 * * * *$- *
Qualif *Jul * * *$1,000,000 * * 1 * * * *$- *
Proposal * * * *Feb * * *$60,000,000 * *5 * * * *$872,727
Qualif *Mar * * *$336,000 * * * * * * * * * * * 1 * * * *$3,360
Qualif *Feb * * *$40,000 * * * * * * * * * * * *1 * * * *$727
My objective is to sum the "WeightedValue" for each row that matches the
following criteria:
1 - Stage = Proposal
2 - Date = Feb
Thank you,
Raphael
|