VLookup

[SammySpaceman]

Is it possible to have VLookup return more than one value at a time?

 

[sbendbuckeye]

Hello JUan,

Your UDF posted above is exactly what I was looking for, thanks for posting it!

I am having one problem when using it. Even though it builds the correct result array, only the first element is displayed in my worksheet, presumably because that is where I entered the formula (eg if I enter the formula in Cell E1 then E1 is the only cell that has a value in it even if more array elements should have displayed in E2, E3, etc.

Am I missing something obvious here? Thanks in advance for any ideas and/or suggestions.

 

[sbendbuckeye]

Any ideas out there on this problem? Thanks!