Billing Goddess wrote...
Thanks, but I had to use vlookup in order for this to work properly.. but I
was able to use the index formula for another application! Thanks
....

You couldn't have used VLOOKUP to solve the question you posed as you
posed. Did you insert a column to the left of your column L that
contained formulas that concatenated the values in your original
columns K and Q? If not, you may think you've solved this, but it's
more likely your formula happenstantially returns the correct value for
the specific data you're using. As the saying goes, a stopped clock
shows the correct time twice a day.