yup.
=IF(ISNA(MATCH($A2,$D:$D,0)),0,INDEX(E:E,MATCH($A2,$D:$D,0)))+IF(ISNA(MATCH($A2,$G:$G,0)),0,INDEX(H:H,MATCH($A2,$G:$G,0)))
yup.
=IF(ISNA(MATCH($A2,$D:$D,0)),0,INDEX(E:E,MATCH($A2,$D:$D,0)))+IF(ISNA(MATCH($A2,$G:$G,0)),0,INDEX(H:H,MATCH($A2,$G:$G,0)))
Wow.. you swim in some deep water teylyn... I just tried that in B2 and it returned #NAME?
Am I missing something?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks