Hi
I wonder if somebody can help me. I need to find a formula that finds which
cost pool split to apply to each cost pools.
Example:

Cost Pool Cost Pool Split Amount A BBB CA
A/BBB/CA 20/30/50 50 =amount*cost pool split
If I use search function it find me position of cost pool only
FE=SEARCH("bbb",A2,1)
I need to check position to "/" to find which cost pool split to apply
Eva