Forum Discussion

Elias_Haddad's avatar
Elias_Haddad
Copper Contributor
Mar 25, 2020

Lookup a random sorted array

Hi All,   I cannot seem to find an answer for my requirements, and hope you can come to my aid please.   Data In Column A I have the names of countries sorted randomly. In Column B I have the n...
Formulas and Functions
Savia's avatar
Savia
Iron Contributor
Mar 25, 2020

Elias_Haddad Both can be done with custom CF rules based on a formula.

 

For 1:

    =MATCH(active cell, column B, 0)

 

For 2:

    =ISERROR(MATCH(active cell, column A, 0))

  • Elias_Haddad's avatar
    Elias_Haddad
    Copper Contributor
    Mar 25, 2020

    Savia 

     

    Thank you for your feedback.

     

    Only partially successful though...

     

    Savia

     

    • Elias_Haddad's avatar
      Elias_Haddad
      Copper Contributor
      Mar 25, 2020
      oops, what happened to the picture I inserted???

Resources