You are correct - In my post, I simply added one row to your original range
--
Wag more, bark less


"Ron Rosenfeld" wrote:

On Fri, 11 Dec 2009 06:20:01 -0800, Brad
wrote:

Taking Ron's idea one step further
add one more row to the table (on top)

-10^99 text1

then the formula would be
VLOOKUP(U24,M1:N9,2) - note that the range has increased by one.

For some reason, I was trying to set that up before and couldn't. Must have
been too early in the morning, but it is preferable. The range should be M1:N8
though.
--ron
.