Vlookup that trim/mid the result in a single formula

[mkyb14]

I'm trying to use a vlookup to reference an account number, and return the managers name in another sheet. Problem is the managers name is backwards and I've been using Trim/Mid to fix this. How can I incorporate a vlookup of a value, return a name but have it flipped and trimmed etc? Normally I'd create another sheet and manually do this, but I'd like to try and not create a bunch of other sheets for single tasks.

Gemini = Raw account list. S column listed mangers names by (LAST, FIRST), column D = account number

Master List = where i'm trying to create a master file of specific accounts by Account number.
Column A = Account number
Column G = Vlookup (column A) against (Gemini!D:G), then return managers name (First Last)

iferror(trim(mid(Gemini!S2&" "&Gemini!S2,FIND(",",Gemini!S2)+1,LEN(Gemini!S2))),"To Be Deleted if no match"))

 

[Peter_SSs]

Thanks Peter, that is slick. I seem to recall something like that, but now after walking through it I can add it to may bag of tricks.

Cheers