Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum of a named range with values based on vlookup results | Excel Worksheet Functions | |||
Value a cell based on vlookup results | Excel Worksheet Functions | |||
vlookup based on results from autofilter | Excel Worksheet Functions | |||
Vlookup to return results of If statement | Excel Worksheet Functions | |||
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL | Excel Worksheet Functions |