View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Not able to complete the task?

Does anyone have any suggestions on my case?
When I use Index function as shown below,

=INDEX(''!O:O,MATCH($B3,'path'!$A:$A,0))
=INDEX('path'!O$2:O$10000,MATCH($B3,'path'!$A$2:$A $10000,0))
=INDEX('path'!O$8000:O$9000,MATCH($B3,'path'!$A$80 00:$A$9000,0))

Excel is not able to complete the task with existing resource, please select
less data or close other application.

Does anyone have any suggestions what cause the problem?
Thanks in advance for any suggestions
Eric