I've found that there are good departments, and bad departments in Lowes. It all boils down to the employees they hire
I buy a lot of paint from Lowe's and have actually had the same problem, sometimes. The employees that only work in the Paint Department are very knowledgeable, but it seems that they will be short staffed and will get any employee to work in that department, and their knowledge is terrible.
Thanks! Your answer is awaiting moderation.