Match Match Then

[Jim]

Hello,

Can you tell me how to write a formula that will look at column A (the date)
then column B (a name) and return the results of column d.

a b c d
e
27-Dec CORENE 36 17 0.47
27-Dec Bob 61 50 0.31
28-Dec CHAD 44 12 0.27
28-Dec VICKIE 45 19 0.42
29-Dec JIM 54 19 0.35
29-Dec CHRISTINA 45 16 0.36

Thank you in advance for the help

 

[Mike H]

Jim,

Try this

=INDEX(E1:E6,MATCH(1,(A1:A6=G1)*(B1:B6=H1),0))

Where G1 is the date and h1 is the name


'This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike

 

[Shane Devenshire]

Hi,

Here is one approach, assuming your first entry is in on row 1. and you have
entered the date and name you want to check for in G1 and G2

=SUMPRODUCT(--(A1:A6=G1),--(B1:B6=G2),D16)

 

[Jim]

Again, perfect

Jim,

Try this

=INDEX(E1:E6,MATCH(1,(A1:A6=G1)*(B1:B6=H1),0))

Where G1 is the date and h1 is the name


'This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike