G'day all,
ok i have this formula
=INDEX($C$2:$C$425,MATCH(D2,IF($B$2:$B$425=E2,$A$2:$A$425),0))
which works fine, I only have one problem I cannot for the life of me work out where or how to insert the IsNA to give me a 0 value if no match found so that I can sum my results-
Any and all help appreciated..
Steve
ok i have this formula
=INDEX($C$2:$C$425,MATCH(D2,IF($B$2:$B$425=E2,$A$2:$A$425),0))
which works fine, I only have one problem I cannot for the life of me work out where or how to insert the IsNA to give me a 0 value if no match found so that I can sum my results-
Any and all help appreciated..
Steve