If statement with different cells

[kuzna26]

Please your help is needed



I have a selection of 30 number each on one in a specific cell in column F1:F30
I have to select only five number that shall be placed in columns H1,H10,H15, H20, H25.

on H9 I will have the Sum of H2:H8
on H14 I will Have the sum of H11:H13
on H19 I will have the sum of H16:H18
on H24 I will have the sum of H21:23
on H29 I wll have the sum fo H26:28


Then on E1:E30 I want write a formula that say
If a number selected in F1:F30 matches with either H1, H10, H15, H20 H25
then I want say for example
F2= 20 and if it matches with H10 then the formula in E2 must say the number in H14 shall be displayed in E2


hope it makes sense
Thanks

[daffodil11]

I'm not sure I follow this or your similar post https://www.excelforum.com/showthread.php?t=982877.

Are you able to attach an example to show your layout and expected results?

If you need to choose values at random from a selection, I'd recommend using a helper column of rand() to generate matches with Large()

[kuzna26]

I'm not sure I follow this or your similar post https://www.excelforum.com/showthread.php?t=982877.

Are you able to attach an example to show your layout and expected results?

If you need to choose values at random from a selection, I'd recommend using a helper column of rand() to generate matches with Large()

Please I have 24 item in E9:E32 I can only select 5 item and they must be placed in either P7,P16,P25,P34,P42
if I unselect on of the 5 item them the corresponding cell in either (P7,P16,P25,P34,P42 ) must be empty

for example if I select for instance one item in E10 if shall be in one of (P7,P16,P25,P34,P42 ) let say P16 then the
number in R24 must the shown in M10


please any help see attachment,