Daviiiiiiddd
New Member
- Joined
- Mar 21, 2013
- Messages
- 1
I'm having a problem with the index-match formula. I have two sheets: one with dates and address and another with dates address and results. I need to make a formula to grab the results from the second sheet based on the MOST RECENT DATE.
=INDEX(test3!C:C,MATCH(test2!B1,test3!B:B,0))
<tbody>
</tbody>
I am using the following results and I need the most recent date result:
<tbody>
</tbody>
I am currently using:
=INDEX(test3!C:C,MATCH(test2!B1,test3!B:B,0))
And it is NOT returning the the result for the latest date. For example: 256 Dawn shows, "Postponed" and not "win", for some reason, my formula is returning the postponed and not the win (I think because I didn't tell it to factor in the date). Can somebody please help me with this?????????????
=INDEX(test3!C:C,MATCH(test2!B1,test3!B:B,0))
2013-03-14 | 1566 Newport | "Index-Match Formula Here" |
2013-03-14 | 1546 Pinnacle | "Index-Match Formula Here" |
2013-03-14 | 256 Dawn | "Index-Match Formula Here" |
2013-03-14 | 498 Savannah | "Index-Match Formula Here" |
<tbody>
</tbody>
I am using the following results and I need the most recent date result:
2013-03-14 | 1566 Newport | Win |
2013-03-8 | 1546 Pinnacle | Win |
2013-03-10 | 256 Dawn | Postponed |
2013-03-14 | 256 Dawn | Win |
<tbody>
</tbody>
I am currently using:
=INDEX(test3!C:C,MATCH(test2!B1,test3!B:B,0))
And it is NOT returning the the result for the latest date. For example: 256 Dawn shows, "Postponed" and not "win", for some reason, my formula is returning the postponed and not the win (I think because I didn't tell it to factor in the date). Can somebody please help me with this?????????????
Last edited: