Calculation Speed (Index/Match vs Vlookup)?
"Ken" wrote in message
...
Bob / Pete ... Thanks
Pete ... recommendation to use HELPER Col ... I am confident this is
correct
... & I am sure this will not make sense to those that are intimate with
Excel ... However, bottom line is ... I am just an Excel hack that prefers
not to work with HELPER Cols. And, I certainly do realize this is a
short-coming on my part (comfort zone).
Forgot to say earlier, don't dismiss helper columns so quickly. They do make
the formulae more maintainable, and remember, you can always hide them so
that they don't get in the way.
|