Forum Discussion
Excel VLOOKUP / Poor Naming Convention
Hi All, I am looking for some advice with regard to V LOOKUP. My company has not followed a strict naming convention within its database. For Example, some records have been created as 'Amazon' so...
It sounds as though Vlookup may not be the best solution for what you are trying to achieve. It sounds as though your data would contain multiple results (eg. Amazon, AMAZON LTD, UK Amazon, etc), whereas the Vlookup function stops searching once it finds the first match within the data. Possibly consider Pivot Tables where you can filter and adjust results within a field.