i saw this post sometime ago and cut it out for future use. yesterday i was
trying to test it out and the lookup solution doesn't work if B1 is blank.
it returns #NA. the other two cells work.

i know that one of the solutions had an if statement and that works but i am
curious why the lookup doesn't work.

thanks for your help.
--
aprilshowers