T
Tom Leslie
I use the hlookup, vlookup and lookup functions in Excel a lot -- they're
really powerful for building automated reports. It's annoying that they
return #N/A when they can't find a lookup value, because I often do sum
totals on a column that may change in length, and the #N/A's are tough to
handle smoothly. (I'm sure there's a test that can trap and handle #N/A, but
I can never find it when I want to.) Anyway, I'd like an additional
parameter for the lookup functions that I could use to tell it to return
blank, 0 or #N/A when the lookup fails.
really powerful for building automated reports. It's annoying that they
return #N/A when they can't find a lookup value, because I often do sum
totals on a column that may change in length, and the #N/A's are tough to
handle smoothly. (I'm sure there's a test that can trap and handle #N/A, but
I can never find it when I want to.) Anyway, I'd like an additional
parameter for the lookup functions that I could use to tell it to return
blank, 0 or #N/A when the lookup fails.