Lookup formula to populate a column based on a name search/match in another table

Thanks very much for sharing this, but unfortunately doesn’t quite help with what I’m looking for. I’ve found something which closer resembles what it is I’m trying to achieve, to consolidate things, here’s a link to that thread and my post which gives a full detail of what I’m looking for here.

If you are able to help with that, it would be great!? Thanks again!