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