| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup table | Excel Worksheet Functions | |||
| Complex LookUp / Match Problem ?? | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
