markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
I’m trying to lookup to hundreds of rows of names in column A. The problem is that there must be some background data that stopping the lookup from working. If I clear a cell with a name in totally and then re-type the lookup will work so there’s some corruption somewhere. I’ve tried copying and paste special to another clear cell but that doesn’t work. Anyone got any ideas how I can solve without clearing each cell and retyping each and every name in manually – there’s about 1000 in total !!!