Hi All,
I am am performing a 2 way lookup within the array below, based on "Month" and "Name", to return the intersecting value/blank.
This works fine, however I need it to return the last value if the "name" Column has a duplicate. (For March I want Jane to display 150, instead of " - ")
<tbody>
</tbody>
The formula I have been using is =VLOOKUP(A10,A2:E7,MATCH($B$9,$A$1:$E$1,0),0)
<tbody>
</tbody>
My problem is when there is a Duplicate in the list of Names, The first value in the array is the result.
Do anyone know a way around this, and returning the value of the last Name?
Any input is much appreciated!
I am am performing a 2 way lookup within the array below, based on "Month" and "Name", to return the intersecting value/blank.
This works fine, however I need it to return the last value if the "name" Column has a duplicate. (For March I want Jane to display 150, instead of " - ")
A | B | C | D | E | |
1 | Jan | Feb | Mar | Apr | |
2 | Jane | 150 | 150 | - | - |
3 | Bob | 150 | 150 | 150 | 150 |
4 | Kim | - | 200 | 200 | 200 |
5 | Tom | - | 120 | 120 | 120 |
6 | Sam | - | 300 | 300 | 300 |
7 | Jane | - | - | 150 | 150 |
<tbody>
</tbody>
The formula I have been using is =VLOOKUP(A10,A2:E7,MATCH($B$9,$A$1:$E$1,0),0)
A | B | |
9 | Mar | |
10 | Jane | - |
11 | Sam | 300 |
<tbody>
</tbody>
My problem is when there is a Duplicate in the list of Names, The first value in the array is the result.
Do anyone know a way around this, and returning the value of the last Name?
Any input is much appreciated!