Quote:
Originally Posted by Spencer101
Format Column A on the "Equipment List" sheet as numbers and all should work out well. It did for me anyway...
|
So, I did that. It didn't seem to do anything until I cleared the (!) message box indicating numbers stored as text. When I changed them all, the look ups worked. That's ok for this sample
My actual spreadsheet has over 12,000 rows of data and converting them all from text to # is locking down my computer. Any other suggestion?