Run Vlookup in each cell?

[smduello]

All -

I have a massive spreadsheet with multiple columns that tries to look
up data on other tabs using Vlookup. Problem is that when I try to
run it, Excel locks up due to the massive amount of data its trying to
lookup. The only think I can think of is to just run the Vlookup in
each cell so that Excel doesn't lock up, but I can't find any way to
do this.

Any ideas?

 

[David McRitchie]

VLOOKUP is used in each cell, and it's not something you can turn on
and off for each each cell. Are you using strictly builtin Worksheet
functions
within your formula or are you using some of your own UDF (User Defined
Functions)
within the formulas.

If you can use INDEX instead it would be faster.
A posting by Niek Otten
http://groups.google.com/groups?oi=djq&ic=1&selm=an_641464519

My page on VLOOKUP is
http://www.mvps.org/dmcritchie/excel/vlookup.htm