"Excel cannot complete this task with available resources"

[philxxx]

i get this massege when copying a lookup function in a large spreadsheet. is
there a way of allocating more resources to Excel to overcome this problem?
the option to "choose less data or close other applications" does not work.