Forum Discussion

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

Elias_Haddad

Copper Contributor

Mar 25, 2020

Savia

Thank you for your feedback.

Only partially successful though...

Savia

Elias_Haddad

Copper Contributor

Mar 25, 2020

oops, what happened to the picture I inserted???

Elias_Haddad
Copper Contributor
Mar 25, 2020
Savia
- Savia
  Iron Contributor
  Mar 25, 2020
  Elias_Haddad You should only write the rule for the active cell, so F1:F5 should just be F1. And you need to make sure that the reference to the other region doesn't move as each cell is considered, so replace G1:G10 with $G$1:$G$10.
  - Elias_Haddad
    Copper Contributor
    Mar 25, 2020
    Savia So I have to create 5 separate CF's to manage the range F1:F5 ? That's a pity because my original set of data has circa 200 names in each column.