When you use VLOOKUP you have the option to have the list containing the
criterion sorted or not sorted, which can lead to confusing results if not
applied correctly.
I have taken to using SUMPRODUCT for my bookkeeping reports. Is there any
need to sort any of the array elements? - or anything else about
SUMPRODUCT( ) which might give an unexpected result?
Kind regards, James Elliott
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
