| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding text using multiple criteria
Is it possible to use something like this formula, amended as required, to
have it display the text from the cell where the first two parts of the formula are true? =SUMPRODUCT(--(WorkSheet!$A$1:$A$370=$B9),--(WorkSheet!$C$1:$C$370=$C9),WorkSheet!P$1:P$370) Or is something totally different needed? Could someone please show what the formula would need to be? Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the lowest value according to multiple criteria | Charts and Charting in Excel | |||
| SUMPRODUCT question, finding data on multiple criteria | Excel Discussion (Misc queries) | |||
| SUM with multiple numeric and text criteria | Excel Discussion (Misc queries) | |||
| finding data with multiple criteria | Excel Discussion (Misc queries) | |||
| Finding a record using multiple combo boxes as my search criteria | Excel Discussion (Misc queries) | |||
![RobN[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
