Quote Originally Posted by rberke
named ranges work fine with almost every excel function, including vlookup. (I discussed problems with max and min earlier).
I looked back at your discussionm on MAX and Min, and admit IU don't really understand your point. Can you explain it again?

On the VLOOKUP point you make, you could use dynamic indexes

= VLOOKUP(M1,A1:B200,COLUMN(B1)-COLUMN(A1)+1,FALSE)

then no need to use the (clumsier) MATCH...INDEX alternative.