try this in H2 and copy paste down
![]()
=IFERROR(MID(G2,FIND(" ",G2)-1+2,LEN(G2)-FIND(" ",G2))&" is "&VLOOKUP(LEFT(G2,FIND(" ",G2)-1),$A$2:$C$15,3,FALSE),"")
try this in H2 and copy paste down
![]()
=IFERROR(MID(G2,FIND(" ",G2)-1+2,LEN(G2)-FIND(" ",G2))&" is "&VLOOKUP(LEFT(G2,FIND(" ",G2)-1),$A$2:$C$15,3,FALSE),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks