VLOOKUP Not Updating when Data Repeated
Hello!
I have a quote tool that uses VLOOKUP formulas. I use userforms to gather data and upload it to an excel sheet. I have noticed that the formula works the first time I input a product. However, if I enter the same product again, the formula seems to only recognize the first instance even though the second instance shows up within the VLOOKUP range. Is there an update function or something that is needed to find these second and third instances of the same product?
Thank you so much for your help!!