Forum Discussion
Solved
Formula required – if it exists
Hi everyone Last year someone on here gave me the most brilliant formula for something, and I am back here again with similar hopes! Is there a way of telling Excel, if Col A contains the wor...
This is my rendition:
=LET(article,LEFT(A1,FIND(" ",A1)-1),const,{"el","m";"la","f";"las","f, pl";"los","m, pl"},VLOOKUP(article,const,2,0))
Everything you've listed sounds do-able.
There are two things needed to give you the best solution possible:
1. Which version of Excel are you using? If you're on 365, the version/build will help determine the functions to which you have access.
2. A small sample of about 10 words. If you could provide a sample of what Column A might look like and then show desired results in Column B, this would be great.
There are two things needed to give you the best solution possible:
1. Which version of Excel are you using? If you're on 365, the version/build will help determine the functions to which you have access.
2. A small sample of about 10 words. If you could provide a sample of what Column A might look like and then show desired results in Column B, this would be great.
This is my rendition:
=LET(article,LEFT(A1,FIND(" ",A1)-1),const,{"el","m";"la","f";"las","f, pl";"los","m, pl"},VLOOKUP(article,const,2,0))- Patrick2788 Yes, that one worked! Thanks a million!
