Quote Originally Posted by jo15765 View Post
Not to step on the toes of @GTO at all, but if you could modify your worksheet that returns the data to how I set it up in the attached workbook you can use a function to return the data and avoid using VBA at all. This may or may not suit your needs, but was just a thought.

Power to VBAExpress!
That formula will work -- but what about handling null/blank values? For example it returns #N/A if there is null or blank lookup in the formula.