I need help fixing this formula in Excel. I have the =left,find formula correct (to get the First name) and i just need to make it into a =right,len-find formula (to get the last name) but i keep getting #VALUE!.

These formulas are searching for a number on a separate sheet to get the names but also seperating with only the first name or the last name.

Correct Left formula on excel: =LEFT(VLOOKUP(A2,'Table'!$A$2:$B$31,2,0),FIND(" ",VLOOKUP(A2,'Table'!$A$2:$B$31,2,0)))

Attempted Right Formula on excel: =RIGHT(VLOOKUP(A2,'Table'!$A$2:$B$31,2,0),LEN(VLOOKUP(A2,'Table'!$A$2:$B$31,2,0)-FIND(" ",VLOOKUP(A2,'Table'!$A$2:$B$31,2,0))))