"scott" <sco### [at] scottcom> wrote:
> The lookup() function only works if the list you are looking up in is 
> sorted in ascending order.  By sorting the cells by column B, 
> concatenate(a1:a9,b1:b9) is no longer is ascending order.

The question is...why?  What use is something that looks things up that 
requires you do its work for it first?

-- 
Tim Cook
http://empyrean.freesitespace.net

Post a reply to this message