can lookup a number to a 10x10 table?
 

...

A1: 1234 (find this value)
B1:K10 : 10X10 matrix (in this matrix)
L1:L10 : Lookup value (and then display this text)

=CHOOSE(MATCH(COUNTIF(B1:K10,A1),{0,1,2}),"Nothing ",INDEX(L1:L10,SUMPRODUCT((B1:K10=A1)*ROW(L1:L10)) ),"More
then one value")

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=369480