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

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

Hi,

The answer is no as TV said. However, there are a lot of useful
improvements to the functions area in addition to the 5 core functions and 8
cube functions:
Feature 2003 2007
Array References 65535 rows, 255 col Limit removed
Maximum length of a formula 1,024 8,192
Number of levels of formula nesting 7 64
Number of function arguments 30 255
Number of dependencies for a single cell that are trackable for partical
recalc 8,192 Limit removed
Number of areas with dependencies trackable for partical recalc 65,536
Limit removed
Number of array formulas that can refer to another worksheet 65,536 Limit
removed
Number of categories availble for custom functions 32 255
Number of rows in a column refered to by an array formula 65,335 Limit
removed
The 93 function in the Analysis ToolPak have been incorporated into Excel
Add-in in Excel

There are other related feature enhancements.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"westy" wrote:

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