I have a large named range (80 columns, 120 rows). Vlookup hangs (processor
pegged at 100%) now that I have created it. Would speed improve if I split
this large range into multiple smaller ones? I am keeping all vlookups
within the same worksheet based on advice from an older thread. I also tried
Index|Match but it was slower. The overall workbook is less than 1MB and is
linked to OLAP.

Thanks,
Kem