pacerfan07
New Member
- Joined
- Jun 2, 2017
- Messages
- 20
I have the following on Sheet1 below. On Sheet2 I just have everyone's Name listed once in column A (John, Kate, and Jim). In column B of Sheet2 I would like to look at the name from column A and see if it matches column A on Sheet1. If it does, then lookup the 2nd most recent occurrence in column B and return the corresponding values in column C. For example John should return 18.
Thanks!
<tbody>
</tbody>
Thanks!
A | B | C | |
1 | John | 11/1/17 | 10 |
2 | John | 11/2/17 | 15 |
3 | Kate | 11/1/17 | 14 |
4 | John | 11/3/17 | 18 |
5 | Kate | 11/2/17 | 20 |
6 | Jim | 11/1/17 | 25 |
7 | Kate | 11/3/17 | 30 |
8 | Kate | 11/4/17 | 40 |
9 | Jim | 11/1/17 | 20 |
10 | John | 11/4/17 | 60 |
<tbody>
</tbody>