How can I make MLOOKUP to ignore blank cells?

1) Hi

I have the data in the following format:
Attachment 1017

Which results in a bunch of commas. (Ignore the #value errors)
Attachment 1018

How can it be dealt with?


2) The algorithm seems to be quite time consuming even on a data range which is not that big. How does it work on big databases?

Thanks

Hi

I have amended the code. UDFs are slow as compared to in-built functions.