I'm looking for a formula that can nest multiple numbers within.
For example if I type 200 in A1 it will return in B1:E1 ( 3,15,62,73 ) in separated cells, if I type 101 in A1 it would return in B1:C1 ( 1,5 ) etc…
Reference :
200 : 3,15,62,73
110 : 7,8,36,42,56
101 : 1,5
For example if I type 200 in A1 it will return in B1:E1 ( 3,15,62,73 ) in separated cells, if I type 101 in A1 it would return in B1:C1 ( 1,5 ) etc…
Reference :
200 : 3,15,62,73
110 : 7,8,36,42,56
101 : 1,5