New 2007 Sumifs formula - is there a new multiple criteria vlookup
Nope, no new lookup functions in Excel 2007.
There are 5 new functions that would be useful to the average user:
AVERAGEIF
AVERAGEIFS
COUNTIFS
IFERROR
SUMIFS
--
Biff
Microsoft Excel MVP
"westy" wrote in message
...
The new sumifs formula is fantastic. Is there a new multiple criteria
vlookup
( as I want to return text) in 2007?. Eg does not need to be an array
formula, can reference columns not ranges etc just like the new sumifs.
I already use
{INDEX('Net Sales'!$O$2:$O$35000,MATCH(1,('Net
Sales'!$Q$2:$Q$35000=D2)*('Net Sales'!$S$2:$S$35000=E2),0)))}
Heres hoping there is.
Thanks Craig
|