I looked at the date in the wrong corner, which is why I assume the ten year span. Forums are a whole new world to me, so I'll be careful next time.

As for my first issue, I did read the preceding comment, and I understood it. I just can't understand why the macro is pulling nothing for many of the acronyms; I'm getting blank cells.

As for my second issue, I wasn't questioning whether the code is correct. I was simply asking why the difference in pairs of parentheses and what the bar symbol meant.

But as I said before, I'm going to try to get it to work the way I need it to. So thanks.