Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Matches
How do I look up or match from the same table in the same cell. Not sure how
to explain so here is the formula I am trying to use but it gives me an error. =MATCH($D2,CA2:CA38,0),MATCH($E2,CA2:CA38,0) $D2 and $E2 are dates and I am trying to match them to a calendar I built. I would like the cell to display a 1 if one of the arguements are true and a 0 if both of them are false. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Multiple Matches | Excel Worksheet Functions | |||
Returning Multiple Matches | Excel Worksheet Functions | |||
Displaying multiple matches | Excel Worksheet Functions | |||
Multiple Matches | Excel Worksheet Functions | |||
Multiple matches using LOOKUP | Excel Discussion (Misc queries) |