VLOOKUP with 2 Criterias

R

Roni

Aladin,

That's true, the array formula takes a lot of time to process big excel
file. Are there any ways to fasten the processing time for array
formula?

Thanks,
Roni
 
A

Aladin Akyurek

Roni said:
Aladin,

That's true, the array formula takes a lot of time to process big excel
file. Are there any ways to fasten the processing time for array
formula?

Thanks,
Roni
Click to expand...

Yes, if you can sort the data, calculate the subranges (in additional
columns, and apply the array formula to calculated subranges.

Why not try the proposal for concatenating, sorting, and invoking a
LOOKUP formula for it will certainly beat the foregoing in performance?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
VLOOKUP returning errors 4
MACRS depreciation formula 2
VLOOKUP MATCH INDEX two conditions / criterias text and date 7
First column of range in VLOOKUP contains formula 2
need formula to return data from one column after comparing 2 othe 3
SQL query with join on substring 5
vlookup for 2 criterias 3

Top