see your other post

--
Biff
Microsoft Excel MVP


"Westy" wrote in message
...
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))}