What's your formula? Is your data sorted?

--
Kind regards,

Niek Otten

"KemS" wrote in message
...
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