UDF MLOOKUP takes too much time. Alternative approach needed.

Originally Posted by oeldere

I think you posted confidential information in your sheet.

Second, where do you have your Mlookup function (in which cell).

Please add also the desired result in your sheet (please no zip file).

1) No there is nothing confidential there
2) MLOOKUPs are in columns C, E, F
3) The desired result would be the same but taking less time to compute
Ans sorry for *zip file, the website did not allow to upload more than 1 mb, so I had to compress it.


Any suggestions are welcomed. Thanks in advance.