Bob, thanks for wanting to help!

I'm up for trying the VBA approach if that's what you prefer; I should be able to do a little research and figure out how to make that function work.

Though I need to show you some other products' pricing table variations & differences in text strings before you get into it; I'd hate for you to not have a complete picture of the entire process. I'll get some screenshots up later today, hopefully in the next couple hours.

As for the text file, we export it from our website program as a .csv file and open it in Excel. For the pricing table, we enter base pricing at the first of the year and then derive later-in-year price increases via simple multiplication formulas. We can convert these cells to values if that is necessary.

Thanks again, and I'll post back shortly!

John