Maybe the discussion a few lines below this one (Sumif - FastExcel, poster
Naz) is interesting for you
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Spencer Hutton" wrote in message
...
Does anyone know the code to emulate this function using a custom VBA
function:
=INDEX(ReturnRange(MATCH(MatchValue,LookupRange,0) )
TIA.
|