Tony,
I think there is an additional complexity. in the example i placed, the org was organized. I have about 10k people in the org so its not organized like the small example I gave you ;-) sorry thats my bad! i was trying to illustrate how it needed to look up the number, not necesarily based on the order of how the names appear in the org data. This data set will come to me monthly, and no way to tell if it will be in the same order every time.



Thanks so much for helping with this, i havent cracked it yet

Carlos