Working on Excel

I have been working on Excel during these days and I have the problem that I didn’t know how to return multiple values from a lookup: some formula like VLookup but that it returns more than one value.

I have found these very useful links

http://office.microsoft.com/en-gb/excel/HA012260381033.aspx

http://www.mrexcel.com/articles/CSE-array-formulas-excel.php

I have tried to resolve my problem using the help explained in the first link but it does not work as I need.

I have finally created a macro to build the incoming array I need.

The next problem I’m facing seems to be something without solution, because I cannot use the references in a “list” of the “Data validation” wizard:

One day later….

I was tired last night. To overcome the problem I pasted the formula in a cell and then I got the reference from that field. I hide the cell and everything works as desired.

Leave a Comment