Forum Discussion

Christine_S_'s avatar
Christine_S_
Copper Contributor
Dec 13, 2022
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...
Excel on Mac
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Dec 13, 2022

    Christine_S_ 

    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))
Christine_S_'s avatar
Christine_S_
Copper Contributor
Dec 13, 2022

Patrick2788 

Hi Patrick! Many thanks.
I am in 365, version 16.54, on a Mac.

Sample attached....

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Dec 13, 2022

Christine_S_ 

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))
  • Christine_S_'s avatar
    Christine_S_
    Copper Contributor
    Dec 13, 2022
    Patrick2788 Yes, that one worked! Thanks a million!
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Dec 13, 2022
      You're welcome. Glad it worked!

Resources