| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return opposite
{=IF(ISNA(MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0)), "",IF(INDEX(PF05!BD$24:BD$
1000,MATCH(CC!$C102,PF05!$BM$24:$BM$1000,0))="",IN DEX(PF05!$BE$24:$BE$1000,M ATCH(CC!$C102,PF05!$BM$24:$BM$1000,0)),""))} The above formula is doing the opposite of what I want it to do, a value should only be returned if there is a corresponding value in the cell of BD Thank you if you can help. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return the smallest value | Excel Worksheet Functions | |||
| Automatic return in an excel worksheet | Excel Worksheet Functions | |||
| search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions | |||
| How to return min, mean, max using criteria? | Excel Worksheet Functions | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
