"Sandy Mann" wrote...
....
. . . it as a VLOOKUP() which does return errors at times.
....

VLOOKUP returns errors only if (1) there's no lookup value found, or (2)
there's an error value in the return value column in the record matching the
lookup value. Your formula will reproduce the second result, but would
unhappily also return error values if there were any error values anywhere
in any of the ranges you're processing, which is UNLIKE VLOOKUP behavior.
OTOH, if there were no error values in any of the ranges and only numbers or
blank cells in the result range, your formula would return 0 rather than an
error value. For a lookup operation, there should be a clearer indication of
failing to find a match.