Hi Gebobs
Thanks for the reply
I added the information you messaged me, but I think I may have it wrong as I cannot get the formula to work

=RIGHT($BG2="","",INDEX,LEN($AA$1:$AT$499,MATCH($B D2,$Z$1 :$Z$499,0)+4,9))-1)