Match Match Then
 

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

Match Match Then
 

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


"Jim" wrote:

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

Match Match Then
 

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),D1:D6)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jim" wrote:

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

Match Match Then
 

Again, perfect

"Mike H" wrote:

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


"Jim" wrote:

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