Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |