Select a value in a range

[grid]

Hello folks,

I have a list of values. I pick one of that values random with a formula: =CHOOSE(RANDBETWEEN(1;8);G1;G4;G7;G10;G13;G16;G19;G22)

I need to pick one of that same values with a formula but that choosen value must be greater or the same then A2.

It took me already some days to accomplish this. Can anybody help me a bit? Thanks so much :-)

Feel free to download my example for a better understanding.


grid

[CARACALLA]

b2=MAX(IF(G1:G22>=A2,G1:G22))

control+shift+enter

[grid]

@CARCALLA, thanks, that will show a 0 value in B2 so that isn't working, it has to pick a random value of the list that is higher or equal then A2

[CARACALLA]

After you type in the formula, don't just press enter.
Instead, press CTRL + SHIFT + ENTER

If you've already entered the formula, then highlight the cell with the formula and press F2.



Then press CTRL + SHIFT + ENTER


When entered correctly, the formula will be enclosed in {brackets}

[grid]

CARACALLA, thanks, now it will return a value but always the highest, it should pick a random value of the list that is higher or equal then A2