Quote Originally Posted by Aaron Blood
It's the index in the VLOOKUP that prompts me to avoid using it in general. The regular ole LOOKUP function seems to be better suited to maintaining its lookup column point of reference. In fact, I would think LOOKUP would be the preferred formula for those who like to name columns.
Maybe we should be starting a new thread on Lookup vs Vlookup? (Vlookup is my preferred method )