Forum Discussion
Merged Cells with XLOOKUP Help
Hello! I have this workbook (not mine), that has over 10,000 entries. I need to do a simple xlookup to match a location number to a location name. The problem is, throughout the entire workbook, ...
Oh trust me I know how awful this is.. The overall design is meant to be used for a program, but I need specific data and this is the only thing I have 'clearance' for to find what I need without going through hoops.
Oh trust me I know how awful this is..
The overall design is meant to be used for a program, but I need...
But does the person who created it, who owns it, know how awful it is? Could the other purpose(s) not be served by a cleaner design? Have you tried to get its awfulness addressed? Would the fact that "experts from the Microsoft Excel forum" have denounced the design carry any weight?
Painful, for sure.