| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with more then one codition
can any one help me to using lookup function with more then one condition,
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup with more then one codition
=INDEX(C2:C20,MATCH(1,(A2:A20="x")*(B2:B20="y"),0) )
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "zia" wrote in message ... can any one help me to using lookup function with more then one condition, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Problem | Excel Worksheet Functions | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
