Pages

08 July, 2024

How to find ceritain value in multiple section and return other value

How should I write this formula


Find the Square section where Value A at (Gary is in 8 in this case), and get the name " Ocho" from list underneath


then find where is Value B, Put Ocho at highlight place in value B section


Then list the rest clockwise


Sample Image:



I tried to put value clockwise by using
=INDEX(D22:D29,,XMATCH(D22:D29,MOD(SEQUENCE(8,,E29-1),8)+1))

No comments:

Post a Comment

Thanks