Maybe something like one of the below formulas (it would help to post an example with the expected resulted).

The INDEX AGGREGATE formula in C8 will work in Excel 2010 or later.

If you have an earlier ver. then maybe something like the formula in C9 which must be entered with CTRL-SHIFT-ENTER.

| A | B | C |

1 | NAME | Date | Total |

2 | Mary Smith | 2/5/2019 | 45 |

3 | Becky Jones | 3/5/2019 | 56 |

4 | Sam Spade | 3/1/2019 | 68 |

5 | | | |

6 | | | |

7 | Lookup | | |

8 | Becky Jones | 3/5/2019 | 56 |

9 | | | 56 |

<colgroup><col style="width:30px; "><col style="width:90px;"><col style="width:86px;"><col style="width:76px;"></colgroup><tbody>

</tbody>

**Spreadsheet Formulas** |

Cell | Formula | C8 | =INDEX($C$2:$C$4,AGGREGATE(15,6,(ROW($A$2:$A$4)-ROW($A$2)+1)/(($A$2:$A$4=$A$8)*($B$2:$B$4=$B$8)),1)) | C9 | {=INDEX($C$2:$C$4,MATCH(1,($A$2:$A$4=A8)*($B$2:$B$4=$B$8),0))} |
<tbody>
</tbody> |

**Formula Array:**
Produce enclosing **{ }** by entering
formula with CTRL+SHIFT+ENTER! |

<tbody>

</tbody>

**Excel tables to the web >> ** Excel Jeanie HTML 4