3 ms·
It sounds like your workflow is quite different from mine. Specifically: 1) As you say, you can use INDEX/MATCH instead of VLOOKUP. I only choose the latter if
by rahimnathwani 9y ago
It sounds like your workflow is quite different from mine. Specifically:
1) As you say, you can use INDEX/MATCH instead of VLOOKUP. I only choose the latter if I'm 100% sure I'm not going to save the sheet. I don't know whether VLOOKUP has performance problems, but at some point someone's going to insert a column and break the references.
2) I've never had a filter (I presume you mean filtering on the content of columns by clicking on the column headers) which affects the value of a formula. I tend to have one-way data flow: inputs are clearly marked (ideally, but not always, on their own sheet(s)), and you use filtering only on output sheets.
I'm not sure about RAM usage. I use Excel much less these days for things with that many rows.