I feel like there may be a better solution than what I'm about to give you, but this should work. I created the attached Excel sample data, which has a tab for the phases and a tab for the people.
I joined the two worksheets together using a join calculation of 1=1. This will essentially duplicate each record in one for the records in the other. But this will allow us to do comparisons on the same row, then aggregate to get the phase.
Next we'll create a calculated field, which I'll call "Current Phase"
IF [Distance]<[Distance (Phases)] THEN
Finally, we can do some aggregation, grabbing the minimum "Current Phase" to get the actual current phase.
I've attached the packaged workbook.
If this helps to answer your question, then please mark this response as helpful or as the "correct answer". This will help others who may have similar questions in the future. Thanks!!
Thanks for replying. Are you able to save the workbook in 10.3.3 so I'm able to open it.
Any further questions on this, Vinay?
Apologies, haven't had a chance to look at this yet.
Will let you know shortly,
This didn't really work for me. It didn't provide what I needed.
Instead I created a calculated field that works out the current phase and then used blending.
Thanks for your help.