B
Brotherharry
I'm having to work with very large data sets using vlookups.
e.g. I've 200k rows with an id in one sheet and I'm looking up
corresponding values in a data range that's 20k rows and 4 columns in
size in another sheet.
I recognise there are probably solutions in moving data off into
Access or whatnot, but hey, I'm here and I like Excel.
so my question is
can I influence the speed of calculation by how my data is structured
in either the source or vlookup range?
e.g. I've 200k rows with an id in one sheet and I'm looking up
corresponding values in a data range that's 20k rows and 4 columns in
size in another sheet.
I recognise there are probably solutions in moving data off into
Access or whatnot, but hey, I'm here and I like Excel.
so my question is
can I influence the speed of calculation by how my data is structured
in either the source or vlookup range?