Quote Originally Posted by Aaron Blood



*1* It's the index in the VLOOKUP that prompts me to avoid using it in general

??

*2* In fact, I would think LOOKUP would be the preferred formula for those who like to name columns.

??

*3* =VLOOKUP(G1,A1:E10,COLUMNS(A:B),FALSE )




*1* I agree with completely .

*2* You have just retracted (albeit sarcastically) so we also agree on that.

*3* Been there! Done that! Doesn?t work! Column B can only be cut and pasted in the 5 column range. Go ahead -- just try pasting column B to the left of column A. Write it down!