I found an interesting entry: http://stackoverflow.com/questions/18656808/how-to-optimize-vlookup-for-high-search-count-alternatives-to-vlookup
The formula is a table one and is entered with Ctrl+Shift+Enter.
I added Application.Volatile to see live updates.
Small limitation: It needs to be entered every 65536 rows if the column is longer.
Brak komentarzy:
Prześlij komentarz