Hi there,
I am looking for a formula to look for the first two words to the left in a data table but also to be able to look for the first word to the left because not all lines have 3 words.
I used the below formula for Elite Bookkeeping and it works but when it has Elite Bookkeeping Services it doesn't work.
=VLOOKUP(LEFT("*"&A68&"*",SEARCH(" ","*"&A68&"*")-1),'JPs Corps'!A:B,2,FALSE)
I am looking for a formula to look for the first two words to the left in a data table but also to be able to look for the first word to the left because not all lines have 3 words.
I used the below formula for Elite Bookkeeping and it works but when it has Elite Bookkeeping Services it doesn't work.
=VLOOKUP(LEFT("*"&A68&"*",SEARCH(" ","*"&A68&"*")-1),'JPs Corps'!A:B,2,FALSE)