Display last text value depending on another cell

I have attached an example spreadsheet showing what I need help with.

To try to explain it, I need to look up the last value for each person listed in another column. So, the people's names will repeat down one column and may or may not have text in the adjacent column. I need to display the last text value adjacent to each person's name.

John Half
Steve
Joe
John
Joe Half
Joe
Steve Done
Matt
John Done
Steve

Table:
John:
Steve:
Joe:
Matt:

Thanks

Hi Willia97

Try using below formula:-

Formula:

Please Login or Register  to view this content.

Enter this using key combination Ctrl Shift Enter..

See attached;- Book1(37).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Willia97,

Try using below formula to suit your revised requirement.

Formula:

Please Login or Register  to view this content.

Enter above formula using ctrl shift enter key combination.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

see the attachment as well:-


Book1(37)(1).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>