pulling data from cells near unique descriptor

I have a feature list from a bacterial genome assembly that has had some nomenclature changes over the years. I am trying to create new columns using the locus_tag, old_locus_tag, gene, and product identifiers to create an easy to read table. The problem I encounter is that not every entry has a gene name, or old_locus_tag. I asked for help here previously but I did not include an example that included this problem. I have attached the old sample with the solve and a new example that provides examples of missing identifiers. Ideally I would like to leave the new cells empty if there is no gene or old_locus_tag for that entry. I cannot post a link yet, but the previous post I referred to is my only other thread.

https://www.excelforum.com/office-36...escriptor.html
link added by Moderator --6JS