Using match, index to return substring

[chuckf201]

My spreadsheet consists of:
column A: single numbers or letters from 1-10 and a-j
column B: first-name sp last-name. (Abe Lincoln, George Washington, etc)

column f: single numbers or letters
column g: return last name only.

how can I combine both following formulas to yield the last name only in column G. (Lincoln, Washington)

<colgroup><col width="55"></colgroup><tbody>
[TD="class: xl82, width: 55"]=trim(RIGHT(B1,LEN(B1)SEARCH("",B1,SEARCH(" ",B11)+1)))
AND
=INDEX(B1:B11,MATCH(F1,LEFT(A1:A11,5),0),2)

Thanks
[/TD]

</tbody>

 

[Dryver14]

in column G =RIGHT(B2,LEN(B2)-FIND("*",SUBSTITUTE(B2," ","*",LEN(B2)-LEN(SUBSTITUTE(B2," ","")))))

 

[chuckf201]

I don't want to get the string in column B. I want to match column F with column A and return column B sub-string to column G.
in other words:
in col g: match column f with column A and return last name from column B.

 

[Aladin Akyurek]

Looks like...

In G1 enter and copy down:

=REPLACE(VLOOKUP(F1,A:B,2,0),1,FIND(" ",VLOOKUP(F1,A:B,2,0))-1,"")

 

[chuckf201]

Aladin - You are magical...thanks--Works great. Well Done