I have excel 2003 and am having problems with integers on the lookup function.
I have to compare two lists of approx 33,000 values, some text and some integers. The lists have have all been formated as text, but when I use the lookup function, all number only part numbers don't find their match.
What can I do?
Bookmarks