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