That's what I was thinking...VLOOKUP is what I've been using in another workbook for another task. The only problem I've encountered from time to time is that a new variation appears (due to manual entry). So, I have to add the new variation to the lookup table. I was hoping to create a more automated method.

Thank you very much for your help!