Vlookup Help

[dan03uk]

Hi,

Im currently creating a vlookup table, but for some of the values i need to look up there are multiple answers, is there away it can give these multiple answers in a drop down list.

 

[Sal Paradise]

Not without VBA as far as I can tell.

 

[xenou]

That was my take as well.

 

[Sal Paradise]

I was thinking multiple array formulas and a validation list dropdown, but unfortunately you'd need a helper table to do that. If you don't mind keeping a helper table, it is doable, but VBA may be a lot easier.