Suppose I have a spreadsheet with 3 columns, thus:
A,A,3
A,B,1
A,C,4
B,A,1
B,B,5
B,C,9
C,A,2
C,B,6
C,C,5

A cell with =lookup("ac",concatenate(a1:a9,b1:b9),c1:c9) returns the value 
4, as is expected.  But if you then sort a1:c9 by column b, the lookup 
returns...3?

What exactly is going on, and how do I *really* get the associated value of 
particular criteria regardless of how a sheet is sorted?

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

Post a reply to this message