MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Ron Berger on January 18, 2002 3:49 PM

I need more than a 1,000 columns to do a hugh look up matrix. Any solutions?

Posted by Russell Hauf on January 18, 2002 3:52 PM

You could transpose your data and use HLOOKUP instead. Of course, if you have both dimensions bigger than 255 this won't work.

Good luck,