Is there a new multiple criteria vlookup in 2007 just like there is the new
sumifs formula eg does not need to be an array formula, can reference columns
instead of cell ranges etc.

I am currently using
{=INDEX('Sheet!$O$2:$O$35000,MATCH(1,('Sheet'!$Q$2 :$Q$35000=D2)*('Sheet'!$M$2:$M$35000=F2),0))}