T
taxmom
Hello,
Can anyone help me with adding two index matches together.
I have the following formula which searches for the city of chicago in the
county of cook if NOT true return zero if true return column 4.
However I need the formula to search as above but also search for Chicago in
Du Page county and return the total of both.
How can I accomplish this in a formula? Is it possible?
=IF(ISNA(INDEX(ilsort,MATCH(1,(INDEX(ilsort,,1)="Totals for City:
CHICAGO")*(INDEX(ilsort,,2)=" County:
COOK"),0),4)),0,INDEX(ilsort,MATCH(1,(INDEX(ilsort,,1)="Totals for City:
CHICAGO")*(INDEX(ilsort,,2)=" County: COOK"),0),4))
Thanks for your help
Can anyone help me with adding two index matches together.
I have the following formula which searches for the city of chicago in the
county of cook if NOT true return zero if true return column 4.
However I need the formula to search as above but also search for Chicago in
Du Page county and return the total of both.
How can I accomplish this in a formula? Is it possible?
=IF(ISNA(INDEX(ilsort,MATCH(1,(INDEX(ilsort,,1)="Totals for City:
CHICAGO")*(INDEX(ilsort,,2)=" County:
COOK"),0),4)),0,INDEX(ilsort,MATCH(1,(INDEX(ilsort,,1)="Totals for City:
CHICAGO")*(INDEX(ilsort,,2)=" County: COOK"),0),4))
Thanks for your help